How to add New Year's Day Mid-Autumn Festival to excel calendar

Hello, the steps to add Mid-Autumn Festival on New Year's Day to Excel calendar are as follows: 1. First of all, we must determine whether the festival in our Excel calendar is a lunar calendar or a solar calendar. To determine the dates of different festivals, here is a formula for calculating dates, which is called "General Birthday Formula" and written as: (y * d+c)-L. To be precise, this formula calculates numbers. 2. Then the value of c is a fixed value, and the monthly distribution of the 24 solar terms is also fixed, so you can directly enter the month and enter the general birthday formula in column E, specifically written as "= int ((right $ b $2,2) * 0.2422+C4))-int ((right $ b $2,2)-6544". Microsoft Excel is a spreadsheet software written by Microsoft for computers using Windows and Apple Macintosh operating systems. Intuitive interface, excellent calculation function and chart tools, coupled with successful marketing, make Excel the most popular personal computer data processing software. 1993, after the release of version 5.0 of Microsoft Office component, Excel began to become the overlord of spreadsheet software on the applicable operating platform. I hope my answer can help you.