怎样把农历的日期变成公历的日期?答:"[$-130000]d"))),下拉完成公历转农历。2. 这个公式不仅转换了日期,还添加了天干地支和生肖。方法三:使用TEXT+MID+ CHOOSE+ YEAR函数 1. A1为农历,B1输入:=CHOOSE(MOD(YEAR(A1)-1900,10)+1,"庚","辛","壬","癸","甲","乙","丙","丁","戊","己")&CHOOSE(MOD(YEAR(A1)-...
怎样将excel农历转为公历?答:"[$-130000]d"))),下拉完成公历转农历。2. 这个公式不仅转换了日期,还添加了天干地支和生肖。方法三:使用TEXT+MID+ CHOOSE+ YEAR函数 1. A1为农历,B1输入:=CHOOSE(MOD(YEAR(A1)-1900,10)+1,"庚","辛","壬","癸","甲","乙","丙","丁","戊","己")&CHOOSE(MOD(YEAR(A1)-...