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

Dates should be entered as =DATE(yyyy;mm;dd), for example, my birthday would be entered as "=DATE(1988;07;25)" For the "years" column, do this: "=INT(MONTHS([cell of person's birthday];TODAY();2) / 12)" For the "months" column, use "=MOD(MONTHS(G4;H4;2);12)". That should give you what you need.