Forum Discussion
Automatically create dates when changing weeks
This issue has now been solved, see attachment of my 12 week rotating roster,
how it works is:- Cell B3 shows week 1 of a 12 week roster, you'll also notice the date in cell C3 is 1-Jan-22 and in cell K4 is an employee name, for week 2 of the 12 week roster just change cell B3 to 2, now notice the date in cell C3 is 8-Jan-22 and in cell K4 is a different name, the names drop down one each week change and the one at the bottom goes to the top and so and so on. now one you get to week 12 the next week reverts back to week one to start the 12 week roster all over again, once you change cell B3 back to week 1 then go to cell A3, this is a dropdown list of 1-5, choose 2 as this is the 2nd of the rotating roster, once you have done this notice the date in cell C3 is has carried on from week 12 and is now the 26-Mar-22, these dates now show the correct dates for each rotating roster for the whole year and which employee is doing which roster for each week of any roster.
hope this all makes sense to you
cheers, Mike T
This issue has now been solved, see attachment of my 12 week rotating roster,
how it works is:- Cell B3 shows week 1 of a 12 week roster, you'll also notice the date in cell C3 is 1-Jan-22 and in cell K4 is an employee name, for week 2 of the 12 week roster just change cell B3 to 2, now notice the date in cell C3 is 8-Jan-22 and in cell K4 is a different name, the names drop down one each week change and the one at the bottom goes to the top and so and so on. now one you get to week 12 the next week reverts back to week one to start the 12 week roster all over again, once you change cell B3 back to week 1 then go to cell A3, this is a dropdown list of 1-5, choose 2 as this is the 2nd of the rotating roster, once you have done this notice the date in cell C3 is has carried on from week 12 and is now the 26-Mar-22, these dates now show the correct dates for each rotating roster for the whole year and which employee is doing which roster for each week of any roster.
hope this all makes sense to you
cheers, Mike T