D2 下拉{=IFERROR(SMALL(IF((WEEKDAY(ROW(INDIRECT(B$1&":"&B$2)),2)<6)*(COUNTIF(F:F,ROW(INDIRECT(B$1&":"&B$2)))=0)+COUNTIF(G:G,ROW(INDIRECT(B$1&":"&B$2))),ROW(INDIRECT(B$1&":"&B$2))),ROW(A1)),"")
方式二 E2=B1
E3{=IFERROR(MATCH(,0/(ISNA(MATCH(ROW($1:$9)+E2,F:F,))*(WEEKDAY(ROW($1:$9)+E2,2)<6)*(ROW($1:$9)+E2<=B$2)+ISNUMBER(MATCH(ROW($1:$9)+E2,G:G,))),)+E2,"")
留言
張貼留言