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

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

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


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Jerry Smith" <Jerry wrote in message ...
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

Hi Jerry,

Look he

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Jerry Smith" <Jerry wrote in message ...
|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

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

see

http://www.cpearson.com/excel/datedif.htm
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Jerry Smith" <Jerry wrote in message
...
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

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

"Jerry Smith" wrote:

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.