PCDVD數位科技討論區

PCDVD數位科技討論區 (https://www.pcdvd.com.tw/index.php)
-   疑難雜症區 (https://www.pcdvd.com.tw/forumdisplay.php?f=34)
-   -   請問 EXCEL 西曆轉農民曆 公式 (https://www.pcdvd.com.tw/showthread.php?t=1069003)

dodorabbit 2015-01-26 07:37 AM

請問 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是要顯示農民曆


所有的時間均為GMT +8。 現在的時間是03:47 AM.

vBulletin Version 3.0.1
powered_by_vbulletin 2025。