|
||
|
Major Member
 
加入日期: Jan 2004 您的住址: mars
文章: 284
|
請問 EXCEL 西曆轉農民曆 公式
=CHOOSE(MOD(YEAR(C4)-1900,10)+1,"庚","辛","壬","癸","甲","乙","丙","丁","戊","己")&CHOOSE(MOD(YEAR(C4)-1900,12)+1,"子","丑","寅","卯","辰","巳","午","未","申","酉","戌","亥")&TEXT(C4,"[dbnum1][$-130000]年m月"&IF(--TEXT(C4,"[$-130000]d")<11,"初","")&TEXT(C4,"[dbnum1][$-130000]d"))
看了網路上的公式,但是一直出現錯誤...請問那些部份要修改 C4到C34是西曆的日期 D4到D34是要顯示農民曆 此文章於 2015-01-26 07:41 AM 被 dodorabbit 編輯. |
|||||||
2015-01-26, 07:37 AM
#1
|
|
