Forum Discussion

M-Tommo2426's avatar
M-Tommo2426
Copper Contributor
Mar 23, 2022
Solved

Automatically create dates when changing weeks

I have a work roster, I am trying to automatically re-populate dates in cells Saturday through to Friday when I change cell B3 which is the week I'm in, currently is 1, when I change B3 to 2 (week 2)...
  • M-Tommo2426's avatar
    M-Tommo2426
    Mar 25, 2022

    Grahmfs13 

     

    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

     

Resources