Does anyone have an Excel spreadsheet that calculates someone's age (in years and months) from the date of birth, please?
This will calculate from d.o.b. to current day with results in two cells (Formula 1 & 2):Cell: A3 = Date of BirthCell: A4 = "=Today()"Formula 1 (years): "=YEAR(A4)-YEAR(A3)"Formula 2 (months): "=MONTH(A4)-MONTH(A3)"
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 hereRegards,Simsy
Simsy,Thank you.That was very helpful.
This thread is now locked and can not be replied to.
iPhone X review
How to find a font: Discover the name of a typeface with these apps
The best iPhone for 2017
Comment créer un compte PayPal pour payer en ligne ?
© Copyright 2017 IDG UK. All Rights Reserved.