Single Rotating Weekly Work Schedule

If your schedule rotates every four weeks, would this work? Take the Daily Schedule template, duplicate it three times, and set the background color of the relevant work days/days off columns in each copy. Then each time you want to add a week, just duplicate the relevant sheet (which already contains the color coded columns)

SG

You could do something like this:

Set up a table to indicate the 4 weekly schedules, Like shown in the top table titled "Weekly Setup". Format the cells for the weeks as check boxes to make selecting work days easily. enter the starting week date in cell A2 of the set up table

In the bottom table titled "Weekly Work Schedule," the first row is a header row.

A2=Week Setup::$A$2 +( ROW()−2)×"7d"

this is shorthand for... select cell S2, then type, or copy and paste from here, the formula:

=Week Setup::$A$2 +( ROW()−2)×"7d"

B2=MOD(ROW()−2, 4)+1

C2=IF(OFFSET(Week Setup::$C$2, $B2−1, (COLUMN()−3)), "WORK", "OFF")

select cell C2, copy

select cell C2 and use conditional formatting to set the color of the cell using the cell formatter. You can open the cell formatter, by single clicking the cell then selecting the "cell" segment, then click the button "Conditional Highlighting…":

select cells C2 thru I2, paste

select cells A2 thru I2, copy

select cell A2 thru the end of column I, paste

Have you considered using iCal? You can add event that repeat.

You have to do little work but it shouldn't be too bad:

Wayne Contello wrote:

Have you considered using iCal?

Just in case it's not obvious, you presumably mean the stock calendar app that comes with OS X. For those who may not know, that used to be called "iCal," but since 2012 (Mountain Lion) has been called "Calendar."

SG

Thanks SG. Yes I meant Calendar It's funny, the image I posted even showed "Calendar" and I still typed iCal.