EXCEL FORMULA FOR CALCULATING AGE FROM BIRTHDAY

  Sherwood 13:12 11 Apr 2006
Locked

Does anyone have an Excel spreadsheet that calculates someone's age (in years and months) from the date of birth, please?

  John B 13:36 11 Apr 2006
  beynac 13:36 11 Apr 2006

This will calculate from d.o.b. to current day with results in two cells (Formula 1 & 2):

Cell: A3 = Date of Birth
Cell: A4 = "=Today()"

Formula 1 (years): "=YEAR(A4)-YEAR(A3)"
Formula 2 (months): "=MONTH(A4)-MONTH(A3)"

  Simsy 14:43 11 Apr 2006

Assuming that the date of birth is in cell A1

=DATEDIF(A1,NOW(),"y") & " years, " & DATEDIF(A1,NOW(),"ym") & " months, " & DATEDIF(A1,NOW(),"md") & " days"

and comes from an excellent Excel site;

click here

Regards,

Simsy

  Sherwood 15:11 11 Apr 2006

Simsy,

Thank you.

That was very helpful.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Best phone camera 2017

Stunning new film posters by Hattie Stewart, Joe Cruz & more

iPad Pro 10.5in (2017) review

28 astuces pour profiter au mieux de votre iPhone