View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
bj bj is offline
external usenet poster
 
Posts: 1,397
Default what is the formula to change date of birth into age

=datedif(birthdate,today(),"y")

"Eddie" wrote:

I am compiling a membership list and need the age because we have an age
limit . Is there a formula to do this using date of birth? Can this be done
without me having to work it out in my head each time!

I am using MSO Excel 2003

Really appreciate any advice.
Thanks.