Birthdate vs age

  • Thread starter Thread starter val
  • Start date Start date
V

val

Does any one know a formula that will convert the
birthdate to an individual age so I don't have to figure
the age manually.

I can't find any information on this item -- assistance is
appreciated.

Thanks
 
Val,

If you had the birthday in A1

=DATEDIF(A1,TODAY(),"Y")

Datedif isn't listed in the function wizard, but can be
found in the help menu.

Dan E
 
Back
Top