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},{"子","丑","寅","卯","辰","巳","午","未","申","...
excel怎么转换农历为公历答:"[$-130000]d"))),下拉完成公历转农历。2. 这个公式不仅转换了日期,还添加了天干地支和生肖。方法三:使用TEXT+MID+ CHOOSE+ YEAR函数 1. A1为农历,B1输入:=CHOOSE(MOD(YEAR(A1)-1900,10)+1,"庚","辛","壬","癸","甲","乙","丙","丁","戊","己")&CHOOSE(MOD(YEAR(A1)-...