怎么计算具体日期的天干地支?有没有公式?

发布网友发布时间：2022-05-26 22:31

共1个回答

热心网友时间：2023-11-22 22:32

只有计算年份的天干地支，在D1中输入年份，其他单元格输入公式
=CHOOSE(MOD(D1-4,10)+1,"甲","乙","丙","丁","戊","己","庚","辛","壬","癸")&CHOOSE(MOD(D1-4,12)+1,"子","丑","寅","卯","辰","巳","午","未","申","酉","戌","亥")

声明：本网页内容为用户发布，旨在传播知识，不代表本网认同其观点，若有侵权等问题请及时与本网联系，我们将在第一时间删除处理。E-MAIL:11247931@qq.com