瀏覽單個文章
dodorabbit
Major Member
 
dodorabbit的大頭照
 

加入日期: 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:37 AM #1
回應時引用此文章
dodorabbit離線中