I am using Excel 2007 and seems the DATEDIF function is no longer available.
What is the formula to calculate ones age based upon a birthdate.

The following formula does not seem to work (if today is 11/14/2008 and
birthdate is 11/13/1958, it results in 55, instead of 54):

=YEAR(Today()) - YEAR(A2)

Thanks

DATEDIF works fine in my Excel 2007.

--
__________________________________
HTH

Bob

"Squid" wrote in message
...
I am using Excel 2007 and seems the DATEDIF function is no longer
available.
What is the formula to calculate ones age based upon a birthdate.

The following formula does not seem to work (if today is 11/14/2008 and
birthdate is 11/13/1958, it results in 55, instead of 54):

=YEAR(Today()) - YEAR(A2)

Thanks

Datedif works in my XL2007. But if you can't, or won't, use Datedif, you can
easily check to see whether the person has had a birthday this year, as in:
=YEAR(TODAY())-YEAR(A2)-(DATE(YEAR(TODAY()),MONTH(A2),DAY(A2))TODAY())

Regards,
Fred

"Squid" wrote in message
...
I am using Excel 2007 and seems the DATEDIF function is no longer
available.
What is the formula to calculate ones age based upon a birthdate.

The following formula does not seem to work (if today is 11/14/2008 and
birthdate is 11/13/1958, it results in 55, instead of 54):

=YEAR(Today()) - YEAR(A2)

Thanks