excel 用函数编出农历大小月份答:农历函数:Sub 农历()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, curDay Dim GongliStr, NongliStr, NongliDayStr Dim i, m, n, k, isEnd,...
Excel 急,求助公历转农历公式答:适用於2007版以上 A2输入西历日期 B2="农历"&TEXT(A2,"[$-130000]m月"&IF(--TEXT(A2,"[$-130000]d")<11,"初","")&"d")C2="农历"&TEXT(A2,"[$-130000]m月"&IF(LEN(TEXT(A2,"[$-130000]d"))=1,"初","")&"d")D2="农历"&TEXT(A2,"[$-130000]m月d日")E2=TEXT(A2...