在excel中怎样制公历和转换成农历

2024-11-25 06:28:57

推荐回答（3个）

回答1：

Excel小技巧

回答2：

　A1为公历，B1输入：=CHOOSE(MOD(YEAR(A1)-1900,10)+1,"庚","辛","壬","癸","甲","乙","丙","丁","戊","己")&CHOOSE(MOD(YEAR(A1)-1900,12)+1,"子","丑","寅","卯","辰","巳","午","未","申","酉","戌","亥")&TEXT(A1,"[dbnum1][$-130000]年m月"&IF(--TEXT(A1,"[$-130000]d")<11,"初","")&TEXT(A1,"[dbnum1][$-130000]d"))

回答3：

转换公司太复杂了，楼主可以做一个公历和农历对照表，直接引用即可，我就是这样做的。
搜索阴阳历对照，有一个网站上就有，从1921年到2019年，你把它复制到excel表格里面就行