SOLVED

Excel Shift Work Calendar Template editing

New Contributor

I would like to use the Shift Work Calendar Template in Excel, but it is only built for 3 jobs.  I need to edit for 6 jobs, but can't figure out how to do it.  I'm sure it's a simple solution, but I'm new to this.

 

If anyone can assist, it would be greatly appreciated.

 

I have attached the template I would like to use.

4 Replies
best response confirmed by NIcholas_Dube (New Contributor)
Solution

@NIcholas_Dube 

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
Using the Family Calendar excel template for Summer Activities for our family. Is there a way to include two different events occurring on the same day? Are dates only drawn form one line in the important dates sheet?