Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / November 2006

Tip: Looking for answers? Try searching our database.

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

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jerry Smith - 15 Nov 2006 20:20 GMT
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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.