每月單數周六與周日全部 顯示 (14760)

C5:AG5=IF(MONTH(DATE($C1,$C2,COLUMN(A1)))<>$C2,"",DATE($C1,$C2,COLUMN(A1)))

C6:AG6=IF(C5="","",RIGHT(TEXT(C5,"AAA")))

C5:AG9格式化=(C$6="日")+(C$6="六")*MOD(COUNTIF($C$6:C$6,"六"),2)