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

来源:学生作业帮助网 编辑:作业帮 时间:2024/04/28 20:26:15
怎么计算具体日期的天干地支?有没有公式?

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

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