Hi, Can anyone get their head round this please as I’m totally stuck!!
I have a column with Date of Births and a row of dates above. The idea of the table is it provides me with a planning tool for the children in our nursery. What I would like it to do is calculate the age according to the date above and display along the row in years and months.
In anticipation of a more enlightened insight, thank you!
<tbody>
</tbody>
******** type="text/javascript" src="safari-extension://com.ebay.safari.myebaymanager-QYHMMGCMJR/c7f5d1c5/background/helpers/prefilterHelper.js">*********>******** type="text/javascript" src="safari-extension://com.ebay.safari.myebaymanager-QYHMMGCMJR/c7f5d1c5/background/helpers/prefilterHelper.js">*********>******** type="text/javascript" src="safari-extension://com.ebay.safari.myebaymanager-QYHMMGCMJR/c7f5d1c5/background/helpers/prefilterHelper.js">*********>******** type="text/javascript" src="safari-extension://com.ebay.safari.myebaymanager-QYHMMGCMJR/c7f5d1c5/background/helpers/prefilterHelper.js">*********>
I have a column with Date of Births and a row of dates above. The idea of the table is it provides me with a planning tool for the children in our nursery. What I would like it to do is calculate the age according to the date above and display along the row in years and months.
In anticipation of a more enlightened insight, thank you!
18 Jan | 18 Jan | 18 Jan | 18 Jan | 18 Jan | 18 Jan | 18 Jan | 18 Jan | 18 Jan | 18 Jan | 18 Jan | 18 Jan | 18 Jan | 18 Jan | 18 Jan | 18 Jan | 18 Jan | 18 Jan | 18 Jan | 18 Jan | 18 Jan | 18 Jan | 18 Jan | 18 Feb | 18 Feb | 18 Feb | 18 Feb | 18 Feb | 18 Feb | 18 Feb | 18 Feb | 18 Feb | 18 Feb | 18 Feb | 18 Feb | 18 Feb | 18 Feb | 18 Feb | 18 Feb | 18 Feb | 18 Feb | 18 Feb | 18 Feb | 18 Mar | 18 Mar | ||
DOB | AGE NOW | Mon 01 | Tue 02 | Wed 03 | Thu 04 | Fri 05 | Mon 08 | Tue 09 | Wed 10 | Thu 11 | Fri 12 | Mon 15 | Tue 16 | Wed 17 | Thu 18 | Fri 19 | Mon 22 | Tue 23 | Wed 24 | Thu 25 | Fri 26 | Mon 29 | Tue 30 | Wed 31 | Thu 01 | Fri 02 | Mon 05 | Tue 06 | Wed 07 | Thu 08 | Fri 09 | Mon 12 | Tue 13 | Wed 14 | Thu 15 | Fri 16 | Mon 19 | Tue 20 | Wed 21 | Thu 22 | Fri 23 | Mon 26 | Tue 27 | Wed 28 | Thu 01 | Fri 02 |
25/4/2016 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
2/11/2015 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 |
1/4/2015 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 |
<tbody>
</tbody>
******** type="text/javascript" src="safari-extension://com.ebay.safari.myebaymanager-QYHMMGCMJR/c7f5d1c5/background/helpers/prefilterHelper.js">*********>******** type="text/javascript" src="safari-extension://com.ebay.safari.myebaymanager-QYHMMGCMJR/c7f5d1c5/background/helpers/prefilterHelper.js">*********>******** type="text/javascript" src="safari-extension://com.ebay.safari.myebaymanager-QYHMMGCMJR/c7f5d1c5/background/helpers/prefilterHelper.js">*********>******** type="text/javascript" src="safari-extension://com.ebay.safari.myebaymanager-QYHMMGCMJR/c7f5d1c5/background/helpers/prefilterHelper.js">*********>