萬年曆 統計假日與非假日人數 (14830)

B3:B33=IF(MONTH(DATE(B$1,F$1,ROW(A1)))=F$1,ROW(A1),"")

C3:C33=IF(B3="","",TEXT(DATE(B$1,F$1,B3),"AAAA"))

I3:I7=IF(H3="","",SUMIF($C:$C,H3,$F:$F))

I3:I7複製到K3:K7

B3:F33格式化=$C3=$H$3