Excel Shift Work Calendar Template editing

[NIcholas_Dube]

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.

[#2 · Accepted 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

[#3]

Thanks for the help

[#4]

@NIcholas_Dube , glad to help

[#5]

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?