排班 依人數 (11876)

B4:Q4=IFERROR(IF(COUNTIF($W$6:$W$19,B2)+(WEEKDAY(B2,2)>=6),"",OFFSET($T$3,MOD(NETWORKDAYS($B$2,B2,$W$6:$W$19)+MATCH($W$3,$T:$T,)-4,COUNTA($T:$T)-1),)),"")

B4:Q4複製到B8:Q8



留言