萬年曆 累計 周 1~4含節日 (12030)

(先) D4:AH4=IFERROR(--($A2&-$B2&-COLUMN(A1)),"")

D3:AH3=RIGHT(TEXT(D4,"aaa"))

D5:AH7=IFERROR(IF(OR(WEEKDAY(D$4,2)={1,4},COUNTIF($B$10:$D$12,D$4)),MAX($C5:C5)+1,""),"")

D5:AH7另解 {=IFERROR(IF(OR(MOD(D$4-2,7)={0,3},$B$10:$D$12=D$4),MAX($C5:C5)+1,""),"")