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

[Cmitchell]

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 : )

[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) .