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.
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
© Copyright 2017 IDG UK. All Rights Reserved.