排班 全自動 (12592)

A3=IF(ROW(A1)>DAY(EOMONTH(NOW(),0)),"",EOMONTH(NOW(),-1)+ROW(A1))

B3=RIGHT(TEXT(A3,"AAA"))

D4{=IF(ISNUMBER(FIND("假",C4))+(WEEKDAY(N(A4),2)>5),"",OFFSET(G$2,MOD(SUM(N(D$3:D3<>""))+MATCH(D$3,G:G,)-3,COUNTA(G:G)-1)+1,))

(全年假日表列 I:J C欄可刪除) D4{=IF(COUNTIF(I:I,A4)+(WEEKDAY(N(A4),2)>5),"",OFFSET(G$2,MOD(SUM(N(D$3:D3<>""))+MATCH(D$3,G:G,)-3,COUNTA(G:G)-1)+1,))