View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default what is the formula to change date of birth into age

You could just subtract the dob from TODAY() to get the number of
elapsed days and divide this by 365.25 to get years, but if you want
the answer to be a bit more elaborate then Chip Pearson shows how
he

http://www.cpearson.com/excel/datedif.htm

Hope this helps.

Pete

On May 16, 12:47 pm, 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.