Miiniilobby
New Member
Hello a quick explanasion:
Picture are there, but in swedish then..
I have an 8-week rotating schedule at work.
Master Schedule:
Weeks 1–8 are listed in the range B1:DH1.
The days have two columns: "Day" (e.g., Monday) and "Time" (e.g., Monday Time). I use this structure because, with the formulas I’ve tested, the schedule otherwise treats "Week 2" of the annual schedule as "Week 1," and I need it to rotate correctly; this data is located in B5:DH5.
Annual Schedule:
The annual schedule includes a starting date (which might sometimes be in mid-August); this cell is located at B1.
The weeks from the master schedule are listed in the range B3:ACC3.
The Monday shift is in B7, and the Monday time is in C7.
I want the row starting at B8 to display both the shift I am working and the working hours, based on the starting week of my master schedule, and I want to be able to drag the formula across to the end of the year.
Picture are there, but in swedish then..
I have an 8-week rotating schedule at work.
Master Schedule:
Weeks 1–8 are listed in the range B1:DH1.
The days have two columns: "Day" (e.g., Monday) and "Time" (e.g., Monday Time). I use this structure because, with the formulas I’ve tested, the schedule otherwise treats "Week 2" of the annual schedule as "Week 1," and I need it to rotate correctly; this data is located in B5:DH5.
Annual Schedule:
The annual schedule includes a starting date (which might sometimes be in mid-August); this cell is located at B1.
The weeks from the master schedule are listed in the range B3:ACC3.
The Monday shift is in B7, and the Monday time is in C7.
I want the row starting at B8 to display both the shift I am working and the working hours, based on the starting week of my master schedule, and I want to be able to drag the formula across to the end of the year.
