Nursery Calendar/DOB

[TheShrew]

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!

[TABLE="width: 1392"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD]18 Jan[/TD]
[TD]18 Jan[/TD]
[TD]18 Jan[/TD]
[TD]18 Jan[/TD]
[TD]18 Jan[/TD]
[TD]18 Jan[/TD]
[TD]18 Jan[/TD]
[TD]18 Jan[/TD]
[TD]18 Jan[/TD]
[TD]18 Jan[/TD]
[TD]18 Jan[/TD]
[TD]18 Jan[/TD]
[TD]18 Jan[/TD]
[TD]18 Jan[/TD]
[TD]18 Jan[/TD]
[TD]18 Jan[/TD]
[TD]18 Jan[/TD]
[TD]18 Jan[/TD]
[TD]18 Jan[/TD]
[TD]18 Jan[/TD]
[TD]18 Jan[/TD]
[TD]18 Jan[/TD]
[TD]18 Jan[/TD]
[TD]18 Feb[/TD]
[TD]18 Feb[/TD]
[TD]18 Feb[/TD]
[TD]18 Feb[/TD]
[TD]18 Feb[/TD]
[TD]18 Feb[/TD]
[TD]18 Feb[/TD]
[TD]18 Feb[/TD]
[TD]18 Feb[/TD]
[TD]18 Feb[/TD]
[TD]18 Feb[/TD]
[TD]18 Feb[/TD]
[TD]18 Feb[/TD]
[TD]18 Feb[/TD]
[TD]18 Feb[/TD]
[TD]18 Feb[/TD]
[TD]18 Feb[/TD]
[TD]18 Feb[/TD]
[TD]18 Feb[/TD]
[TD]18 Feb[/TD]
[TD]18 Mar[/TD]
[TD]18 Mar[/TD]
[/TR]
[TR]
[TD]DOB[/TD]
[TD]AGE NOW[/TD]
[TD]Mon 01[/TD]
[TD]Tue 02[/TD]
[TD]Wed 03[/TD]
[TD]Thu 04[/TD]
[TD]Fri 05[/TD]
[TD]Mon 08[/TD]
[TD]Tue 09[/TD]
[TD]Wed 10[/TD]
[TD]Thu 11[/TD]
[TD]Fri 12[/TD]
[TD]Mon 15[/TD]
[TD]Tue 16[/TD]
[TD]Wed 17[/TD]
[TD]Thu 18[/TD]
[TD]Fri 19[/TD]
[TD]Mon 22[/TD]
[TD]Tue 23[/TD]
[TD]Wed 24[/TD]
[TD]Thu 25[/TD]
[TD]Fri 26[/TD]
[TD]Mon 29[/TD]
[TD]Tue 30[/TD]
[TD]Wed 31[/TD]
[TD]Thu 01[/TD]
[TD]Fri 02[/TD]
[TD]Mon 05[/TD]
[TD]Tue 06[/TD]
[TD]Wed 07[/TD]
[TD]Thu 08[/TD]
[TD]Fri 09[/TD]
[TD]Mon 12[/TD]
[TD]Tue 13[/TD]
[TD]Wed 14[/TD]
[TD]Thu 15[/TD]
[TD]Fri 16[/TD]
[TD]Mon 19[/TD]
[TD]Tue 20[/TD]
[TD]Wed 21[/TD]
[TD]Thu 22[/TD]
[TD]Fri 23[/TD]
[TD]Mon 26[/TD]
[TD]Tue 27[/TD]
[TD]Wed 28[/TD]
[TD]Thu 01[/TD]
[TD]Fri 02[/TD]
[/TR]
[TR]
[TD]25/4/2016[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]2/11/2015[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]1/4/2015[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[/TR]
</tbody>[/TABLE]


******** 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">*********>

 

[jtakw]

Hi,

I have an idea what you're trying to do, but I'm not quite understanding your description/sample...
Are you creating a table Monday thru Friday for the entire year? And future years?
If so, that would be cumbersome to use and look at...
As I don't know exactly what your requirements are, first thing I would do is to try to streamline the worksheet to show and include only pertinent information I need for whatever purpose.

 

[dave2018]

Can I suggest that you have the Full Date in 1 cell, and not separated into 2.

In B1 you should put today's date, for the AGE NOW column.

[TABLE="class: outer_border, width: 500, align: left"]
<tbody>[TR]
[TD]B1[/TD]
[TD]=TODAY()[/TD]
[/TR]
</tbody>[/TABLE]



---------------------------------

In C1 Put the first date that you want shown. in your case it was Mon, Jan 01, 2018 and so on...

in B2, (eg. the first child's "AGE NOW"), put the following formula:

[TABLE="class: outer_border, width: 500, align: left"]
<tbody>[TR]
[TD]B2[/TD]
[TD]=INT((B$1-$A2)/365)[/TD]
[/TR]
</tbody>[/TABLE]


you can then drag it across and down your data set.

Pls let us know if you have any questions.