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


On 3 Feb 2005 19:32:38 -0800, "2rrs" wrote:

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



WendyMc wrote:
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

"WendyMc" wrote:

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