Spreadsheet that calculates chronological ages. It works (I hope!) correctly for months of different lengths etc. (No awkward cludges of dividing days by 30 to get months.)
First tab on the sheet is set up so you can enter a whole class. The second tab is just for quickly checking single dates of birth.
The main calculations in the first tab are carried out in columns D to J, which are hidden. If you look at the formulae, you will see that the formula is far from elegant - but calculating chronological ages is not an elegant process! I realise that the year calculation could be simpler, but I couldn't be bothered to edit it...
First tab on the sheet is set up so you can enter a whole class. The second tab is just for quickly checking single dates of birth.
The main calculations in the first tab are carried out in columns D to J, which are hidden. If you look at the formulae, you will see that the formula is far from elegant - but calculating chronological ages is not an elegant process! I realise that the year calculation could be simpler, but I couldn't be bothered to edit it...
Something went wrong, please try again later.
This resource hasn't been reviewed yet
To ensure quality for our reviews, only customers who have downloaded this resource can review it
Report this resourceto let us know if it violates our terms and conditions.
Our customer service team will review your report and will be in touch.
£0.00