In Excel, for birthdays, the common lunar calendar coincides with the day

Perhaps a lot of people because of traditional habits, will have a lunar birthday, so bring a curious question, birthday to which year the lunar calendar will coincide? Do you have to check it? Well, you are ruthless, although there are 19 years of the lunar calendar will coincide one said, in fact, the number of years interval is indeed nearly 19 times times the number, the "Public Lunar fun query. xls" To dispel doubts, open the Excel file.

As long as the first entry of the lunar calendar year and month and whether the leap month (only the light green lattice can be lost), will automatically calculate the designated years to 2050 corresponding Gregorian calendar, the lunar calendar is a leap month, the following is not a leap month to calculate the birthday, and finally on the "repeat" column on For instance, the 17-born brother of the Lunar New Year of May 66 is more depressed, and his first lunar calendar has not yet been repeated. In fact, the reason is that the year also has a lunar May.

In addition to the annual Gregorian calendar, the second and third can be used for the mutual search of the lunar calendar, if you are interested, you can try to enter the first day of the 1901, more than 100 years, the earliest spring festival in the Gregorian calendar January 21, and only 1 days. If you are interested in research, you can also learn some Excel tips from this document.