THE EXCEL FORMULA SUBTRACTS THE DATE OF BIRTH FROM THE CURRENT TIME TO CALCULATE THE AGE, AND THE AG

Set the cell format to "Numeric", enter the date of birth in b2, and calculate the age as =int((year(today())year(b2)))+if((month(today())month(b2))<0,-1,0))).

The following formulas are applicable to date formats such as: 1976-7-1, 1976-7, and numeric formats such as numeric formats, but not to text formats such as.

if(b2<3000,int(year(now())1900-rounddown(b2,0)),int(year(now())year(b2)))

For example, my birthday is September 11, 1985.

Enter =(today()-date(1985,9,11)) 365

Format cells to keep one decimal place. Calculate the approximate value.

Suppose your date is on A1 (e.g. 2001-5-6).

Enter in B1.

int(year(now())int(year(a1))

Excel age calculation is accurate to the year, month and day.

=datedif(g15,"2012/8/31","y")&"Years.

or =text(datedif(g15,"2012/8/31","d"),"YY year m month d day")

formula"2012/8/31"Replace it with the cell where the date is located.

That's it. =datedfi(g15,date(year(today())8,31),"y")。year(today()) can also be specified as 2012

Illustrate. For example, there is ** as follows:

It is required to calculate the whole number of years.

Step 1: Enter the formula =rounddown((now()-a2) ,0) in b2

d3=year(today())year(c3), column d cell format should be set to regular.

It is not practical to calculate the exact date of birth based on the current date and age in Excel**, for example, today is October 7, 2015, and the age is 20, then only the year of birth is 1995, and the specific date is unknown.

But in Excel, age can be calculated by date of birth, and the specific method:

1) Launch Excel and open the worksheet, enter the formula "=year(today()-y)" into the cell.

2) Press "Ctrl+Enter" key to get the result when you finish typing, and then use your mouse to hold down the left button and drag down the fill handle to fill the formula into other cells.

3) Right-click the currently selected cell area, select the "Format Cell" command in the shortcut menu to open the "Format Cells" dialog box, and select the "General" option in the "Classification" list box.

4) Click the "OK" button to close the "Format Cells" dialog box, and select the cell area to get the current age value you need.

It's impossible.

Depending on the situation, functions such as datedif, days360, date, etc., or date subtraction, can usually be used for date arithmetic.

But what age is usually the age, and if you go back to the current date, you can only get the year of birth, and at most it can only be the month, not the date of birth.

Addendum: For example, today 2011 is March 8, and it is impossible to calculate when a 20-year-old person was born. This also includes the treatment of whether it is full-term or not.

Broadly speaking, people born in 1991 are 20 years old. If you're looking at March 8, 1991, it's easy to do

date(year(a1)-20,month(a1),day(a1))

Assuming that a1 is the age and b1 is the birthday, enter =date((year(b1)-a1),month(b1),day(b1))) in c1

The date of birth can be calculated.

It can be counted to the year, which is as follows:

1. Use two date functions: enter the function in the first cell (e.g., a1)."=year（today（））", which is the return for the current year.

2. Enter your age in cell A2.

3. Enter in cell A3"=a1-a2+1" This is the year of birth, not the date format.

4. If you need the date format, enter it in cell A4"=date(a3)”

If the age can be accurate to a few months and a few days, it is still possible, if it is only a few years old, it is not possible, only the years can be counted.

Unable to fulfill your request.

Because age cannot be converted to the date of birth, and age itself does not contain a date content, it cannot be converted.

There is no date in the age, and it is not possible to ask for a date of birth.

But the year of birth can be calculated. Just use the formula.

Find an excel almanac on the internet and adapt it yourself a little.

The specific steps are as follows: copy

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

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

3. Then you can see the result in the pop-up window.

Material Tools: Excel2010

1. First of all, we will open our target operation**, showing the personnel and the corresponding date of birth.

2. Click the mouse to the column C that needs to display the age.

3. Then select column C, right-click and select Format Cells in the right-click menu.

4. The cell format window pops up, and select the numeric option in the cell content category on the left.

5. Modify the original default decimal place from 2 to 0, which is similar to Arabic numerals.

6. Return to **, click the mouse to the C2 cell 7 of the formula to be formulated, enter =year(today())year(b2)8, press the enter key, and the content displayed at this time is the corresponding age.

The formula is "=datedif(b2,now(),.""y"The b2 bit of the cell stores the date of birth.

=year(now())year(the cell where the data of the month of birth of the bai is stored) +1, the meaning of the formula is zhi, subtract the year of rebirth from the dao year of this year, and add 1, that is, the answer is age. This age is usually used for the registration of cadres and employees. Don't forget to format the cells used to store formulas as numeric values.

Column B formula: =days360(a1,now()) 365, select the numeric value as the cell format, don't be the date type.

With datedif

A1 Birthday B1 Current Date.

Just subtract the numbers from two cells.

If 1982-1-1

In cell A1, you need to show the age in cell B2.

B2 enters the formula =year(now())int(left(a1,4)).

I can only use the year, not the month and the day.