萬年排班 分一般與周六日 (12819)

C2下拉=TEXT(B2,"AAA")

D2下拉 {=IF(WEEKDAY(B2,2)<6,INDEX(G:G,SMALL(IF((COUNTIF(H:H,G$2:G$21)=0)*(G$2:G$21<>""),ROW($2:$21)),MOD(SUM(N(WEEKDAY(ROW(INDIRECT("2024/1/1"*1&":"&B2)),2)<6))-1,COUNTA(G:G)-COUNTA(H:H))+1)),OFFSET(H$2,MOD(SUM(N(WEEKDAY(ROW(INDIRECT("2024/1/1"*1&":"&B2)),2)>5)),COUNTA(H:H)-1),))