如何将农历日期转换为公历日期?答:2. C列农历简称中C1公式是:=RIGHT(B1,LEN(B1)-8)。3. 下面是此自定义函数相关的代码:Public Function NongLi(Optional XX_DATE As Date)Dim MonthAdd(11), NongliData(99), TianGan(9), DiZhi(11), ShuXiang(11), DayName(30), MonName(12)Dim curTime, curYear, curMonth, curDayDim...
Excel怎样将农历转换成公历?答:2. C列农历简称中C1公式是:=RIGHT(B1,LEN(B1)-8)。3. 下面是此自定义函数相关的代码:Public Function NongLi(Optional XX_DATE As Date)Dim MonthAdd(11), NongliData(99), TianGan(9), DiZhi(11), ShuXiang(11), DayName(30), MonName(12)Dim curTime, curYear, curMonth, curDayDim...