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.