Traditional Culture Encyclopedia - The 24 Solar Terms - How to convert solar calendar date into lunar calendar date in Excel?
How to convert solar calendar date into lunar calendar date in Excel?
1, the computer opens the Excel table and lists the dates.
2. Then enter the formula of the lunar calendar = text (a2, "[$- 130000] yyyy-m-d").
3. After entering the formula, press Enter to convert the solar calendar into the lunar calendar.
4. Just drop down and copy the formula.
- Previous article:202 1 Good morning copywriting in friends circle of vernal equinox
- Next article:What is the origin of the shocking solar terms?
- Related articles
- As a general, the town is an ancient city, and the water is greasy and the mountains are soft during the Spring Festival.
- What are annual work and daily work?
- Winter solstice greetings 2022 pictures
- How to write a composition about the winter solstice?
- Once the thyroid nodule becomes cancerous, what signal will appear?
- Which five solar terms are the twenty-four solar terms?
- How often does the throttle have to be cleaned? What's the throttle for?
- What does the Shahe period mean?
- The origin and custom of the simple winter solstice
- What is the agricultural proverb of winter solstice?