Calculate age

  • Thread starter Thread starter Luís Jorge
  • Start date Start date
L

Luís Jorge

Hi

I need a function to calculate the age of a person starting on birthday.

Thank you

Luis Jorge
 
Hi Luis
=DATEDIF(A1,B1,"y")+(B1-DATE(YEAR(A1)+DATEDIF(A1,B1,"y"),MONTH(A1),DAY(A1)))/(DATE(YEAR(A1)+DATEDIF(A1,B1,"y")+1,MONTH(A1),DAY(A1))-DATE(YEAR(A1)+DATEDIF(A1,B1,"y"),MONTH(A1),DAY(A1)))

where A1 is the birthdate and B1 the date that you want to calculate the
birthdate at - if you want to use the current date you can either put =NOW()
in B1 or change B1 in the formula to NOW()

Hope this helps

JulieD
 
Back
Top