![]() |
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)
|
|---|
請問 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。