Nursery Calendar/DOB

T

TheShrew

New Member
Joined
Mar 24, 2018
Messages
1
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">*********>
 

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.
Sort by date Sort by votes
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.
 
Upvote 0
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.
 
Upvote 0
You must log in or register to reply here.

Similar threads

Vintage79
  • Solved
Count consecutive days and gaps between days
Replies
2
Views
218
Vintage79
Vintage79
Sandeep Warrier
  • Question Question
Calculate No. of Working Days based on Shift Pattern
Replies
2
Views
151
Tetra201
Tetra201
D
  • Solved
Sumifs or Countifs question
Replies
3
Views
48
Fluff
Fluff
N
  • Question Question
Marco, IFS and XLOOKUP but certainly happy to be wrong
Replies
2
Views
446
N0t Y0urs
N
D
  • Solved
Formula to extract data for multiple critera
Replies
2
Views
63
Trebor76
T

Forum statistics

Threads
1,224,823
Messages
6,181,179
Members
453,021
Latest member
Justyna P

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top