F2:F29 輸入1~28
F30:F32=IF(F$29+ROW(A1)>DAY(EOMONTH(DATE($D$2,D$6,1),0)),"",F$29+ROW(A1))
G2:G32=IF(F2="","",IF(COUNTIF(K:K,DATE(D$2,D$6,F2))+(COUNTIF(L:L,DATE(D$2,D$6,F2))=0)*(WEEKDAY(DATE(D$2,D$6,F2),2)>5),"",OFFSET(B$1,MOD(MATCH(D$10,B:B,)+COUNTIF(G$1:G1,"><")-3,COUNTA(B:B)-1)+1,)))
留言
張貼留言