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!

18 Jan18 Jan18 Jan18 Jan18 Jan18 Jan18 Jan18 Jan18 Jan18 Jan18 Jan18 Jan18 Jan18 Jan18 Jan18 Jan18 Jan18 Jan18 Jan18 Jan18 Jan18 Jan18 Jan18 Feb18 Feb18 Feb18 Feb18 Feb18 Feb18 Feb18 Feb18 Feb18 Feb18 Feb18 Feb18 Feb18 Feb18 Feb18 Feb18 Feb18 Feb18 Feb18 Feb18 Mar18 Mar
DOBAGE NOWMon 01Tue 02Wed 03Thu 04Fri 05Mon 08Tue 09Wed 10Thu 11Fri 12Mon 15Tue 16Wed 17Thu 18Fri 19Mon 22Tue 23Wed 24Thu 25Fri 26Mon 29Tue 30Wed 31Thu 01Fri 02Mon 05Tue 06Wed 07Thu 08Fri 09Mon 12Tue 13Wed 14Thu 15Fri 16Mon 19Tue 20Wed 21Thu 22Fri 23Mon 26Tue 27Wed 28Thu 01Fri 02
25/4/20161111111111111111111111111111111111111111111111
2/11/20152222222222222222222222222222222222222222222222
1/4/20152222222222222222222222222222222222222222222222

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

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
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.

B1=TODAY()

<tbody>
</tbody>



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

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:

B2=INT((B$1-$A2)/365)

<tbody>
</tbody>


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

Pls let us know if you have any questions.
 
Upvote 0

Forum statistics

Threads
1,213,546
Messages
6,114,251
Members
448,556
Latest member
peterhess2002

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