View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Squid Squid is offline
external usenet poster
 
Posts: 4
Default Age based on birthdate

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