萬年曆與休假人員 (14451)

AD4:AF4=REPT(AA4+3,MONTH(DATE($B1,$B2,AA4+3))=$B2)

B5:AF5=IF(B4="","",RIGHT(TEXT(DATE($B1,$B2,B4),"AAA")))

B6:AF16=REPT("X",COUNTIFS($AH:$AH,$A6,$AI:$AI,DATE($B$1,$B$2,B$4)))