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

J

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. 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
 
N

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
 
J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel formula calculating age 4
Age based on birthdate 2
How do I Modify Julian calendar restriction of 1900 2
New computer, how do i move outlook 365 ENTIRELY? 0
Excel - Calculate age from DOB in years, months days 7
Calculating Date of next birthday 4
Calculating age with If statement 2
Calculating Age from Birthdate 4

Top