Using Excel to find age

[Guest]

I would like to use Excel and enter the days months and year in a cell of each persons birthdate. Then I would like to enter the todays date, year, and month so it will calculate the results and display how old the person is. I don't know if this is possible or not. I thought it would be nice to have Excel to calculate the results of a persons age.

Any ideas how to accomplish this task?

 

[Michael Hopwood]

Chip has a good page on this:

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

--
Michael Hopwood (Phobos)

I would like to use Excel and enter the days months and year in a cell of

each persons birthdate. Then I would like to enter the todays date, year,
and month so it will calculate the results and display how old the person
is. I don't know if this is possible or not. I thought it would be nice to
have Excel to calculate the results of a persons age.

 

[Kevin M]

Eric,

if you enter their DOB in A1, and today's date in B1, in
C1 you subtract B1 from A1. so in C1 the formula is =B1-
A1. from there, how would you like to break it down? just
doing this (Make sure you format this cell as a number)
will give you the number of days old a person is. if you
then divide the formula by 365.25, you'll get years as a
decimal figure. =(B1-A1)/365.25

I'm 24 and my birthday is December 23, so i'm 24.89 years
old doing it this way.
HTH
Kevin M

-----Original Message-----
I would like to use Excel and enter the days months and

year in a cell of each persons birthdate. Then I would
like to enter the todays date, year, and month so it will
calculate the results and display how old the person is.
I don't know if this is possible or not. I thought it
would be nice to have Excel to calculate the results of a
persons age.

 

[Guest]

You are actually going to type in today's date? Excel
already knows today's date: it's TODAY(). The person's age
in days is TODAY() - Birthdate. So a rough estimate of the
person's age in years is INT((TODAY() -
Birthdate)/365.25). If you want an age that is exactly
what the person would say if you ask them their age today
and their birthday is tomorrow, even in a leap year, and
given that 1900 was not a leap year, you'd better think
awhile.

-----Original Message-----
I would like to use Excel and enter the days months and

year in a cell of each persons birthdate. Then I would
like to enter the todays date, year, and month so it will
calculate the results and display how old the person is. I
don't know if this is possible or not. I thought it would
be nice to have Excel to calculate the results of a
persons age.