How do I calculate age from birthdate to present in Excel?

[Guest]

I have a list of names with birthdates and would like to calculate each ones
age in years, months, and days from the present day. I am using Excel 2003
SP2. I see how to use the Today function to get the present day. A
subtraction yields the number of days from 1/1/1900. In date format I get a
date earlier than the birthdate. I use the following formula: (Today -
birthdate)/365 to yield decimal years. I am presently changing the format of
the box to yield a number with decimal places. I would like to have the
result show up as years, months, days, in other words, the age of the
individual, not a date. Can anyone help me?

Jerry Smith

 

[Ron de Bruin]

See
http://www.cpearson.com/excel/datedif.htm#Age

and
http://www.cpearson.com/excel/datedif.htm

 

[Niek Otten]

Hi Jerry,

Look here:

http://www.cpearson.com/excel/datedif.htm

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I have a list of names with birthdates and would like to calculate each ones
| age in years, months, and days from the present day. I am using Excel 2003
| SP2. I see how to use the Today function to get the present day. A
| subtraction yields the number of days from 1/1/1900. In date format I get a
| date earlier than the birthdate. I use the following formula: (Today -
| birthdate)/365 to yield decimal years. I am presently changing the format of
| the box to yield a number with decimal places. I would like to have the
| result show up as years, months, days, in other words, the age of the
| individual, not a date. Can anyone help me?
|
| Jerry Smith

 

[Bernard Liengme]

=DATEDIF(A1,NOW(),"y") & " years, " & DATEDIF(A1,NOW(),"ym") & " months, " &
DATEDIF(A1,NOW(),"md") & " days"

see

http://www.cpearson.com/excel/datedif.htm

 

[Guest]

Thanks to all of you that showed me the link to the solution to my age
calculation/display question. I added the Datedif calculations and get the
exact result in the cell I wanted.

By the way, I didn't realize I am running Excel 2000 at home until I looked
last night. I typed in Datedif in help and came up with the following
explaination of its origin: "This function is provided for compatibility with
Lotus 1-2-3."

Jerry Smith