Formula to work out someones age

  • Thread starter Thread starter mikey
  • Start date Start date
M

mikey

I am putting together a database using excel and wish to enter a persons
date of birth as a column and then have excel work out the persons age in
the next column. Can anyone tell me the formula I should be using to do
this?

I'm using excel 97 on windows 95

Regards

Mike

(e-mail address removed)
 
This will return years, months and days:
=DATEDIF(D9,NOW(),"y")&" years, "&DATEDIF(D9,NOW(),"ym")&" months,
"&DATEDIF(D9,NOW(),"md")&" days"
 
Back
Top