Forum Discussion
Excel Shift Work Calendar Template editing
With such template it's a lot of manual work
- in Shift and Jobs copy one of jobs (e.g. #3) column into 3 new to the right
- define job data as needed
- check one by one which names are applied for the cells for job3 and apply similar for job4, etc. Copy/paste such names using name box on top left from the grid, just replace within them Job3 on Job4, etc.
- at the bottom of each month insert 3 empty rows
- copy/paste Job3 formula for the first date into first date for Job4
- replace within formula names with Job3 on names with Job4 and reference on cell C6 on reference on cell C6
- drag this cell to the right till end
- repeat for Job5, Job6
- repeat above for each month
- open Conditional Formatting box and adjust Apply To ranges; use F2 to edit within bar
In attached one job for one month is added
With such template it's a lot of manual work
- in Shift and Jobs copy one of jobs (e.g. #3) column into 3 new to the right
- define job data as needed
- check one by one which names are applied for the cells for job3 and apply similar for job4, etc. Copy/paste such names using name box on top left from the grid, just replace within them Job3 on Job4, etc.
- at the bottom of each month insert 3 empty rows
- copy/paste Job3 formula for the first date into first date for Job4
- replace within formula names with Job3 on names with Job4 and reference on cell C6 on reference on cell C6
- drag this cell to the right till end
- repeat for Job5, Job6
- repeat above for each month
- open Conditional Formatting box and adjust Apply To ranges; use F2 to edit within bar
In attached one job for one month is added
- Thanks for the help
NIcholas_Dube , glad to help
- SergeiBaklan
Is there a way to add a quarterly change in shift patterns?
I would like to see what the calendar would look like if I were to change the shifts from:
NNNNxxxxxDxxNNNxxDDxxxNNxDDxxx
to
MMxxxxMMxxxxMMMxxxMxxxxxxMMxxx
but on a quarterly basis.
