Excel自动怎么计算天干地支五行?答:1、根据年份计算天干,输入以下公式,然后向下填充公式 =CHOOSE(MOD(A2-3,10)+1,"癸","甲","乙","丙","丁","戊","己","庚","辛","壬")公式表示:以A2单元格的年份减去3,被10整除后的余数加1后,作为从天干序列中取数的依据。2、根据年份计算地支,输入以下公式,然后向下填充公式 =...
如何用excel将12位的数字转化为60甲子天干地支答:转换成一个天干地支可以这样:=LOOKUP(MOD(A1-1,10),{0,1,2,3,4,5,6,7,8,9},{"甲","乙","丙","丁","戊","己","庚","辛","壬","癸"})&LOOKUP(MOD(A1-1,12),{0,1,2,3,4,5,6,7,8,9,10,11},{"子","丑","寅","卯","辰","巳","午","未","申","...