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 - 15 Nov 2006 20:27 GMT
See
http://www.cpearson.com/excel/datedif.htm#Age
and
http://www.cpearson.com/excel/datedif.htm

Signature
Regards Ron de Bruin
http://www.rondebruin.nl
>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
[quoted text clipped - 7 lines]
>
> Jerry Smith
Niek Otten - 15 Nov 2006 20:29 GMT
Hi Jerry,
Look here:
http://www.cpearson.com/excel/datedif.htm

Signature
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
[quoted text clipped - 7 lines]
|
| Jerry Smith
Bernard Liengme - 15 Nov 2006 20:32 GMT
=DATEDIF(A1,NOW(),"y") & " years, " & DATEDIF(A1,NOW(),"ym") & " months, " &
DATEDIF(A1,NOW(),"md") & " days"
see
http://www.cpearson.com/excel/datedif.htm

Signature
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
>I have a list of names with birthdates and would like to calculate each
>ones
[quoted text clipped - 10 lines]
>
> Jerry Smith
Jerry Smith - 16 Nov 2006 18:01 GMT
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
> 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.