怎样把农历的日期变成公历的日期?答:巳","午","未","申","酉","戌","亥")&TEXT(A1,"[dbnum1][$-130000]年m月"&IF(--TEXT(A1,"[$-130000]d")<11,"初","")&TEXT(A1,"[$-130000]d")))。2. 这个公式简化了输入,让公历转农历更加方便。方法四:使用自定义函数 1. 下图所示,我们在B2输入公式段誉:=nongli(A1...
Excel怎样将农历转换成公历?答:巳","午","未","申","酉","戌","亥")&TEXT(A1,"[dbnum1][$-130000]年m月"&IF(--TEXT(A1,"[$-130000]d")<11,"初","")&TEXT(A1,"[$-130000]d")))。2. 这个公式简化了输入,让公历转农历更加方便。方法四:使用自定义函数 1. 下图所示,我们在B2输入公式段誉:=nongli(A1...