Converting Date of Birth to Age

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can anyone please help me? is there a function in excel to convert Date of
Birth data into Age? or a forumula to help?

Many thanks
Wendy
 
I should have added that I have subtracted today's date then divided by 365,
converted to a number field - but this seems a bit crude!

Thanks again

Wendy
 
If the age is in a separate column use
=YEAR(TODAY())-YEAR(A2- the column with the birthdate in
it)Will calc age each time you open the worksheet
 
In general, it isn't documented in Help. I believe you could find it in
XL2000(?), but it isn't there in other versions.
 
Your formula will calculate the age the person will attain on their birthday
in the current year, not necessarily the age they would report today.

Let's say a person was born on December 31, 1970. On January 1, 2005, your
formula says the person is 35. He/she won't be 35 for almost 12 months.
 
If you are going to use "d" as the 3rd argument to DATEDIF, you can forget the
function and just subtract. Your formula is the same as (B1-A1)/365.25.

That formula can give errors when the 2nd date is very close to the birthday,
with the age changing a day or two early or late.

For example, if the birthdate is 1/15/2003, the age does not pass 1 until
1/16/2004. On 1/15/2004, when it should be exactly 1, the result is 0.999316.

The correct formula for age in years is =DATEDIF(A1,B1,"y")
 
Back
Top