EXCEL2003 solar calendar to lunar calendar formula

You need a plug-in to convert the solar calendar into the lunar calendar. I'm afraid the formula can't do this.

The calculation of the lunar calendar is very complicated. In addition to calculating the date of the month, you should also calculate the solar terms, because you can determine which month the leap month is, and you won't know the next month until the leap month is determined. For such a complicated calculation, the Observatory is generally responsible for calculating the lunar calendar.

Note that it is a calculation, which needs to be calculated day by day ~ unlike the Gregorian calendar, you can directly calculate any day with a formula.