每人每月出差天數 (14345)

F2:J13{=SUM(TRANSPOSE(MMULT(COLUMN(A:NB)^0,(DATE($L$2,1,ROW($1:$366))>=TRANSPOSE($A$2:$A$9))*(DATE($L$2,1,ROW($1:$366))<=TRANSPOSE($B$2:$B$9))*(MONTH(DATE($L$2,1,ROW($1:$366)))=ROW(A1))*(YEAR(DATE($L$2,1,ROW($1:$366)))=$L$2)))*ISNUMBER(FIND(F$1,$C$2:$C$9)))

週六日扣除{=SUM(TRANSPOSE(MMULT(COLUMN(A:NB)^0,(DATE($L$2,1,ROW($1:$366))>=TRANSPOSE($A$2:$A$9))*(DATE($L$2,1,ROW($1:$366))<=TRANSPOSE($B$2:$B$9))*(MONTH(DATE($L$2,1,ROW($1:$366)))=ROW(A1))*(YEAR(DATE($L$2,1,ROW($1:$366)))=$L$2)*(WEEKDAY(DATE($L$2,1,ROW($1:$366)),2)<6)))*ISNUMBER(FIND(F$1,$C$2:$C$9)))