Hi All
I am new to the forum so hello !
I need some help with putting together what is basically a list of items that need checking on certain dates over the next 3 years and I want to view in a planner so Jan - Dec for the next 3 years across the top items and dates to check down the side.
At the moment I am manually entering the dates next to the item then blocking in the date under the year / month.
What I would like to do is for the date to automatically color under the month / year.
I have seen some of your good work on calendars etc but just can't find the correct means of doing this.
Can anyone help? As you may be able to tell I am not an excel master.
Thanks
I am new to the forum so hello !
I need some help with putting together what is basically a list of items that need checking on certain dates over the next 3 years and I want to view in a planner so Jan - Dec for the next 3 years across the top items and dates to check down the side.
At the moment I am manually entering the dates next to the item then blocking in the date under the year / month.
What I would like to do is for the date to automatically color under the month / year.
I have seen some of your good work on calendars etc but just can't find the correct means of doing this.
Can anyone help? As you may be able to tell I am not an excel master.
Thanks