Excel Gregorian calendar conversion solar terms

A2 Enter the Gregorian calendar date

B2= Lunar New Year &; TEXT(A2, "[$- 130000]m month"&; IF( - TEXT(A2，"[$- 130000]d ")& lt； 1 1, "Chu", ")&; “d”)

C2= "Lunar New Year"&; TEXT(A2, "[$- 130000]m month"&; If (len (text (a2，"[$- 130000]d ")= 1，" Chu "，" ")&； “d”)

D2= Lunar New Year &; Text (A2, "[$- 130000]m month D day")

E2=TEXT(A2, "[$- 130000]e year lunar calendar"&; If (len (text (a2，"[$- 130000]d ")= 1，" Chu "，" ")&； “d”)

F2 = text (A2, "[$- 130000] YYY Lunar Month M" &；; If (len (text (a2，"[$- 130000]d ")= 1，" Chu "，" ")&； “d”)

The results of the above five formulas are slightly different. Please test and choose the format you like.

Or the A5 custom format is -[$- 130000] "Lunar calendar" m "month" d "day" (or other formats can be set by reference).

Lunar leap month will add 1, for example, July will show August, and August will be postponed to September ... and 65438+ February will be postponed to 65438+ March.