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;

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.

Huawei P10 review

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

An overview: What leading creative agencies are doing to improve diversity

New iPad, iPhone SE & Red iPhone 7 on sale now