- 帖子
- 6
- 主題
- 3
- 精華
- 0
- 積分
- 9
- 點名
- 0
- 作業系統
- WIN7
- 軟體版本
- office2013
- 閱讀權限
- 10
- 性別
- 女
- 註冊時間
- 2018-8-16
- 最後登錄
- 2021-2-4
|
[發問] 求救~~~轉人國曆自動轉換農曆(閏月問題無法克服~
請問有神人會解這個嗎??
如果要寫VBA請教我1.2.3不然我不太會
需求:輸入國曆轉農曆~~可是碰上閏月的就不對了!!
我目前使用的函數是
=CHOOSE(MOD(YEAR(M3)-1900,10)+1,"庚","辛","壬","癸","甲","乙","丙","丁","戊","己")&CHOOSE(MOD(YEAR(M3)-1900,12)+1,"子","丑","寅","卯","辰","巳","午","未","申","酉","戌","亥")&TEXT(M3,"[dbnum1][$-130000]年m月"&IF(--TEXT(M3,"[$-130000]d")<11,"初","")&TEXT(M3,"[dbnum1][$-130000]d"))
拜託幫幫忙啦!!!!有人會嗎?
PS我不要用萬年曆~但如果是製表改VLOOKUP我也可以接受
但那個表我咕狗好久我都找不到!! |
|
發表於 2019-10-10 15:07
| 
