萬年曆 只顯周 1~5 (12065)

C4=MOD(DATE(C2,C3,1)-2,7)+1

E3:I7=IF(MONTH(8^($C$4>5)-$C$4+DATE($C$2,$C$3,ROW(A1)*7-7+COLUMN(A1)))=$C$3,DAY(8^($C$4>5)-$C$4+DATE($C$2,$C$3,ROW(A1)*7-7+COLUMN(A1))),"")



留言