依民國年月 自動改變日與星期 (14632)

B3:AC3輸入 1~28

AD3:AF3=REPT($AC3+B3,MONTH(DATE($G1+1911,$J1,$AC3+B3))=$J1)

B2:AF2=IF(B3="","",RIGHT(TEXT(DATE($G1+1911,$J1,B3),"AAA")))