Regarding the algorithm of the date of birth, what is the formula for calculating age based on the d

22 years old. To be exact, 22 years, 2 months and 5 days. The premise of this calculation is that the two dates you are talking about are Gregorian calendars.

22 years old, we are 22 years old there.

There is no such thing as a false age, but the statement is different in each place.

We are Chinese, and we should use the virtual age system!

1985 should be 23 years old!

Add one more year old and you should be 23 years old

23, because you still have almost a year in your mother's womb, so you should add 1, our biology teacher said.

The legal age is calculated on an annual basis, i.e

2007-1985 = 22 years old, March 2, 2007 is your first birthday, after this day to March 2, 2008 will be counted as 22 years old.

There is a folk saying that the age is imaginary, which is calculated from the beginning of the formation of life, that is, it is 10 months from the mother's womb to before you are born, close to 1 year, so usually the folk will add one year old to you to count 23 years old.

It should be 23 years old. 2007-1985 + 1 (because the birthday has passed) = 23, and the actual age is years.

The real age is 22 years old, and the imaginary age is 23 years old.

The formula for calculating age based on date of birth is:d ataif function. Enter the formula =dateif(c2,today(),y"That's it.

Description of the formuladateif has 3 parameters, the first parameter is the start date, the second parameter is the end date, and the third parameter is the unit of comparison. Note that this formula does not apply to the date of birth in the format "yyyymmdd".

The second method:today function. Enter the formula =(today()-e2) 365, if there is a decimal after the decimal point, change the data format to keep only the whole number.

Description of the formulaThis formula is relatively simple, the today() function gets the specific date now, subtract the specific date of birth, that is, the specific number of days, there are 365 days in a year, and then divide by 365 to calculate how many years, that is, age. Note that the date of birth in the format "yyyymmdd" also does not apply to this formula.

The method of calculating the age of the ID number is:

1.To calculate age, you need to subtract the year of birth on your ID card from the current year. We can use the year function to get the current year=year(now()).

The 8-digit digit starting from the 7th digit of the ID number represents the date of birth. The year of birth is a 4-digit number starting from the 7th digit, and the year of birth is extracted using the mid function.

3.Merging the above two parts gives you the final formula for the cell: =year(now())mid(a2,7,4).

The formula for calculating age based on date of birth is as follows:Operating Equipment: Dell laptops.

the state system: win10

Operating procedure: excel**.

1. First of all, open the required excel** and enter the page. Upright.

2. Then enter the formula "=(today()-c28) 365" into the cell after the date of birth, and press enter to confirm.

3. Then in the pop-up window, you can see the knot clear the fruit.

The calculation is as follows:

1. The calculation of imaginary age and age.

There is no fixed algorithm for imaginary age. At this time, the commonly used method of calculating age in China is based on the calendar year after birth, that is, one year old at birth, and then one year old every new year. Generally according to the Lunar New Year, there are also according to the Gregorian calendar.

For example, a baby born at the end of December is one year old after birth, one year old on January 1 of the Gregorian calendar or after the local Lunar New Year. In this way, the baby is only a few days old and is already 2 years old. This method of calculation is more practical.

2. Calculate the age of one year.

One year old = current year of birth. One year old, also known as the full age of Tan, refers to the total number of years or birthdays that have elapsed from birth to the calculation of age.

For example, the census was conducted at 0:00 on July 1, 1990. Babies born on 15 December 1989 are 2 years old based on their imaginary age.

In fact, it has only been more than six months, and I haven't had a birthday yet. According to the first year of life, it should be less than one year old, that is, 0 years old.

The age of a one-year-old is usually 1 to 2 years younger than expected. It is a commonly used method of calculating age in demographics. One year old - 0 years old at birth, one year old per calendar birthday.