Age based on birthdate

  • Thread starter Thread starter Squid
  • Start date Start date
S

Squid

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
 
Back
Top