Excel to Calculate Ages(in Yrs&Mths) from DOBs?

Cmitchell | 11:02 Sun 06th Nov 2005 | Technology

2 Answers

Hi Folks,

I'm wondering if anyone can help. I need to calculate some ages, in years and months, from a long list of birth dates. I am sure there must be a simple (& quick!) way to do this using an Excel Spreadsheet but I can't seem to find (in the help menus) or work out how to do it. I am okayish at spreadsheets etc [as I did ECDL exam a couple of years ago!] I haven't yet entered the dates of birth, as I want to know in which format to enter them before I begin e.g.
23/06/2000 or 23/06/00
Many thanks in advance for your help and time!
Kindest Regards
Mitchell : )

internet & technology

recording music played by my computer

Answers

1 to 2 of 2

Best Answer

No best answer has yet been selected by Cmitchell. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.

kempie

You will need to enter the year in full e.g. 11/12/1989

Use the following formulae

Years... =DATEDIF(A1,TODAY(),"y")
Months.. =DATEDIF(A1,TODAY(),"ym")

kempie

BTW if you want the days also

=DATEDIF(A1,TODAY(),"md")

All 3 formulae are based on you needing the ages at today's date (whenever "today" may be). If you require the ages at a fixed date either substitute TODAY() with the cell reference containing that date or using DATE(year,month,day) e.g. DATE(2005,11,6) .

1 to 2 of 2

Do you know the answer?