EXCEL FORMULA FOR CALCULATING AGE FROM BIRTHDAY

  Sherwood 13:12 11 Apr 06
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 06
  beynac 13:36 11 Apr 06

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 06

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 06

Simsy,

Thank you.

That was very helpful.

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

Best phone camera 2016/2017: Galaxy S7 vs iPhone 7 vs Google Pixel vs HTC 10 Evo vs OnePlus 3T vs…

1995-2015: How technology has changed the world in 20 years

These are the Best Christmas Ads and Studio Projects of 2016

Super Mario Run preview | Hands-on first impressions of Super Mario Run: Mario's iPhone & iPad…