指定日 星期 出現次數 (13日 黑色星期五) (13194)

E2=SUMPRODUCT(N(WEEKDAY(DATE(ROW(INDIRECT(B2&":"&B5)),COLUMN(A:L),C2),2)=C5))

G2{=IFERROR(SMALL(IF(WEEKDAY(DATE(ROW(INDIRECT(B$2&":"&B$5)),COLUMN(A:L),C$2),2)=C$5,DATE(ROW(INDIRECT(B$2&":"&B$5)),COLUMN(A:L),C$2)),ROW(A1)),"")

H2=IF(G2="","",MOD(G2-2,7)+1)