Free rotating shift roster template (Excel)
A rotating roster moves staff or crews through the same sequence of day, night and off shifts on a fixed cycle, so 24/7 cover is shared evenly. This template sets out two common cycles for four teams: 4-on-4-off over four weeks, and 2-2-3 (Panama), which repeats every 14 days. Enter the cycle start date and copy the pattern forward.

Copying the cycle forward by hand every month?
In RosterElf you set the cycle once and it projects forward, so next month’s roster is already there, and staff see their shifts in the app.
Your download has started.
What’s in the file
- A 4-on-4-off tab: 4 teams over a 4-week cycle
- A 2-2-3 (Panama) tab: 4 teams over 2 weeks, 42 hours a week
- Day, night and off codes filled in for every team
- A Legend tab with codes and the Continental and DuPont patterns
The two cycles side by side
Both sheets use 12-hour day (D) and night (N) shifts and four teams, so one team is on days and one on nights every day of the year.
| 4-on-4-off | 2-2-3 (Panama) | |
|---|---|---|
| One team’s cycle | 4 days, 4 off, 4 nights, 4 off | 2 on, 2 off, 3 on, then 2 off, 2 on, 3 off |
| Repeats every | 16 days | 14 days for one shift type |
| Teams for 24/7 cover | 4 | 4 |
| Weekends | Move through the week, so weekends off vary | Every second weekend off, Friday to Sunday |
| Often used in | Manufacturing, healthcare, utilities | Security, policing |
In the file, each team is one row and each day one column. Enter your cycle start date at the top, then copy the block of columns to the right to run the cycle into the following weeks; for a different rotation, type your own codes over one sheet. The legend tab lists the codes. Want a definition first? Read what a rotating roster is. Rostering fly-in fly-out swings instead? Use the FIFO swing roster.
More roster templates and guides
The file lays out shift patterns only; it does not check rest breaks, maximum hours or pay. Check your award on fairwork.gov.au. Disclaimer.
Rotating roster FAQ
-
Put dates or day numbers across the top and teams or staff down the first column, with a legend for your codes (D day, N night, OFF rest day). Map one full cycle for the first team, then start each other team a few days later in the same pattern. Copy the cycle to the right to extend it. This template has two cycles laid out for four teams.
-
Two are built in: 4-on-4-off, where each team works four shifts then has four off, and 2-2-3 (Panama), a 14-day cycle that gives every other weekend off. For a continental or custom rotation, type your own codes over one of the sheets, then copy the pattern forward.
-
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.
-
No. The template lays out the pattern only. It does not check the rest break between shifts, count hours against your award or work out pay. Check your award’s rules on minimum breaks between shifts and maximum hours on the Fair Work website before you publish a cycle, especially when nights rotate into days.
-
Yes. Update the relevant cells when staff swap, and note who originally held the shift. For a process that keeps rotating cover intact, see our guide to managing shift swaps.
Next week’s roster from this week’s, in one click
For when copying the sheet every week becomes the job.
Save a week as a template and copy it forward
- Save any roster as a reusable template
- Copy last week’s roster instantly
- Clone individual shifts across days
- Staff see their shifts on the iPhone and Android app