Converting Date of Birth to Age

[WendyMc]

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

 

[WendyMc]

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

 

[Jason Morin]

See:

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

HTH
Jason
Atlanta, GA

 

[PAR]

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

 

[Myrna Larson]

In general, it isn't documented in Help. I believe you could find it in
XL2000(?), but it isn't there in other versions.

 

[Myrna Larson]

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.

 

[2rrs]

This will return decimal years;
=DATEDIF(A1,B1,"d")/365.25

 

[Myrna Larson]

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")