How do I make a rotating shift schedule in Excel?

Set up a grid with dates across the top row and employee names down the first column, then create a legend for your shift codes (D = Day, N = Night, OFF = rest day). Map the first week of the rotation by hand, then use cell-referencing formulas like =OFFSET or direct references to shift each worker into their next position in the following weeks. Our free template comes pre-built with this layout — or follow the step-by-step section above. For a wider walkthrough, see our guide on how to create a staff roster.

How do I create a shift roster in Excel?

Lay out a matrix with staff down column A and time periods (days or weeks) across the top, then fill the cells with shift codes. For a rotating roster, add a legend and use formulas to repeat the pattern across the cycle. Excel ships with generic schedule templates, but they are built for US workweeks and rarely match Australian shifts or breaks — this template is purpose-built and works in both Excel and Google Sheets. You can also compare free shift schedule template formats to pick the right one.

What is a 2-2-3 rotating shift?

A 2-2-3 (or Panama) rotation runs on a repeating 14-day cycle: two days on, two days off, three days on, then two off, two on, three off. It gives teams every other weekend off while keeping a 24/7 operation fully staffed. You can map this pattern in the template by setting your shift codes and copying the cycle forward. For more on rotation length and rest, read our guide on scheduling breaks compliantly.

What rotation patterns does this template support?

The template handles common patterns like 4-on-4-off, 2-2-3 (Panama), continental shifts and custom rotations. Adjust the cycle length and the pattern codes to match how your operation runs, then copy the pattern forward to extend cover.

How do I set up a new rotation cycle?

Define your shift codes (for example D = Day, N = Night, OFF = Off), fill in the week-1 pattern for each employee, then copy that pattern forward across the weeks to extend coverage. Adjust the cycle length to match your roster.

How many weeks should I plan ahead?

Most rotating rosters work in 4–6 week cycles. Plan at least one full rotation, plus a week or two for visibility, so staff can plan their personal lives around their shifts. Publishing the cycle early also reduces last-minute swap requests.

Does this template manage fatigue or calculate pay?

No — this is a planning template only. It does not track hours worked, validate fatigue-management rules, or calculate wages, penalties or award entitlements. For automated compliance checks and pay-aware scheduling, use rostering software instead of a spreadsheet, and check your obligations with Fair Work.

Can I handle shift swaps in this template?

Yes — update the relevant cells when staff swap, and note who originally held the shift in the Notes column. For a process that keeps rotating cover intact, see our guide to managing shift swaps and our Fair Work shift swap policy overview.

FREE TEMPLATE Last updated 26 June 2026

Free rotating shift roster template (Excel)

Manage rotating shift patterns fairly across your team. Perfect for 24/7 operations in healthcare, aged care and other continuous-cover workplaces where staff cycle through day, night and off shifts.

Rotating shift roster

Excel format (.xlsx) • Ready to download

Day / night / off pattern layout

Multi-week rotation cycles

Clear pattern legend

Notes for handovers

No signup required. Works with Excel and Google Sheets.

This rotating shift roster template is a general planning tool only. It does not calculate wages, penalties, overtime or award entitlements, and it does not validate fatigue-management requirements. For pay-aware scheduling and compliance support, use dedicated rostering software and check your obligations with Fair Work. It does not constitute legal, HR, or professional advice and should not be relied on as a substitute for advice specific to your business, workforce, or circumstances.

References HR Hub disclaimer Modern Awards Fair Work

What's in this template

Multi-week rotation planning

Shift pattern rows

Day, night and off shifts laid out as repeating rotation cycles for each role.

Employee names

One row per staff member so you can see who is on which pattern at a glance.

Weekly cycle columns

Columns track the rotation across multiple weeks (week 1, week 2, week 3, week 4).

Pattern legend

A clear key explains the shift codes — D for day, N for night and OFF for rest days.

Notes column

Capture handover details, swaps or special arrangements against any shift.

Cycle length setting

Set the number of weeks in your rotation so the pattern repeats cleanly each cycle.

How rotating patterns work

Each employee follows a rotation cycle through different shift types. The template shows this pattern across multiple weeks, so everyone knows when they’re on days, on nights, or off.

Employee	Week 1	Week 2	Week 3	Week 4
Sarah Jones	D D D D - -	N N N N - -	OFF	D D D D - -
James Smith	N N N N - -	OFF	D D D D - -	N N N N - -
Emma Wilson	OFF	D D D D - -	N N N N - -	OFF

Legend: D = Day shift, N = Night shift, OFF = Day off, - = Weekend off

How to make a rotating shift schedule in Excel

Four steps to build one from scratch

1. Set up the grid

Put dates across the top row (use SEQUENCE with EOMONTH to fill a month fast) and employee names down column A from A2.

2. Define your shift codes

Establish a legend — D = Day, N = Night, E = Evening, OFF = rest day — so every cell reads at a glance.

3. Map week 1 manually

Block out the base rotation pattern for the first week — who is on days, nights and off — for each person.

4. Auto-rotate later weeks

Use cell-referencing formulas (=OFFSET or direct references) to shift each worker to their next position in the weeks that follow.

Prefer to skip the setup? The free template above already has the rotation grid, legend and notes built in. For more on laying out a reusable grid, read our guide to designing roster templates.

How to use this template

Download and go in four quick steps

Download

Grab the Excel file — no signup, opens in Excel or Google Sheets.

Add your staff

List everyone in the rotation, one employee per row.

Set the patterns

Fill in the D / N / OFF cycle for each person across the weeks.

Share or print

Post it for the team or export to PDF for the noticeboard.

Who uses this template

Ideal for 24/7 operations

Healthcare

24/7 nursing and hospital ward coverage

Aged care

Round-the-clock care across day and night shifts

24-hour operations

Security, manufacturing and other continuous-cover teams

Running a care facility? See our dedicated guide to rostering healthcare staff and tips for planning compliant cover across aged care teams.

When Excel stops keeping up

Rotating rosters in Excel work until the patterns grow. Once you're tracking pattern changes, juggling swaps mid-cycle and watching fatigue across nights, a spreadsheet becomes a full-time job. RosterElf's drag-and-drop rostering builds the rotation for you, factors in availability, and shares it straight to your team's phones.

Start free trial See rostering software

Rostering guides

Plan smarter rotations with these how-to guides

Related templates

Explore more free roster templates

FAQ

Rotating shift roster FAQ

Set up a grid with dates across the top row and employee names down the first column, then create a legend for your shift codes (D = Day, N = Night, OFF = rest day). Map the first week of the rotation by hand, then use cell-referencing formulas like =OFFSET or direct references to shift each worker into their next position in the following weeks. Our free template comes pre-built with this layout — or follow the step-by-step section above. For a wider walkthrough, see our guide on how to create a staff roster.
Lay out a matrix with staff down column A and time periods (days or weeks) across the top, then fill the cells with shift codes. For a rotating roster, add a legend and use formulas to repeat the pattern across the cycle. Excel ships with generic schedule templates, but they are built for US workweeks and rarely match Australian shifts or breaks — this template is purpose-built and works in both Excel and Google Sheets. You can also compare free shift schedule template formats to pick the right one.
A 2-2-3 (or Panama) rotation runs on a repeating 14-day cycle: two days on, two days off, three days on, then two off, two on, three off. It gives teams every other weekend off while keeping a 24/7 operation fully staffed. You can map this pattern in the template by setting your shift codes and copying the cycle forward. For more on rotation length and rest, read our guide on scheduling breaks compliantly.
The template handles common patterns like 4-on-4-off, 2-2-3 (Panama), continental shifts and custom rotations. Adjust the cycle length and the pattern codes to match how your operation runs, then copy the pattern forward to extend cover.

You appear to be visiting from the UK