Traditional Culture Encyclopedia - Almanac inquiry - 20 1906 lunar calendar
20 1906 lunar calendar
You can subtract by extracting text left and right.
1. If only the year is calculated without considering the month, it is assumed that the data starts from cell A2.
Then the formula is as follows:
=year (today ()-left (a2,4)
Fill down the formula as follows:
2. If you need to calculate the month, the formula is as follows:
= dateif（date（left（a2，4），right（a2，2）， 1），today（），“y“）
As shown in the figure below:
- Previous article:Dream of mother's omen
- Next article:202 1.5. 19 Gregorian calendar
- Related articles
- In December of the lunar calendar in 2022, when is the best time to enter the house?
- Which of the following browsers is the fastest?
- Looking for the old almanac in the old almanac
- Laohuangli electronic edition
- 202165438+February is the best day to open the market, and it will open this month.
- What is Red Sand Day?
- The yellow calendar ebbs and flows.
- In June 2022, I made an inquiry list of auspicious days of the zodiac.
- Women are snakes' wedding calendars. What is the most detailed symbol of a female snake? 0? three
- In March 2020, a boy born in 1 1 was named after eight characters. What are the five elements?