Free template· Excel, opens in Google Sheets

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.

rosterelf-rotating-shift-roster.xlsx
The rotating roster’s 4-on-4-off sheet: four teams cycling through four day shifts, four off, four nights and four off, so one team is on days and one on nights every day

File checked No signup Or build this cycle online, free →

The download

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
Download Excel (.xlsx)
Only on this page

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-off2-2-3 (Panama)
One team’s cycle4 days, 4 off, 4 nights, 4 off2 on, 2 off, 3 on, then 2 off, 2 on, 3 off
Repeats every16 days14 days for one shift type
Teams for 24/7 cover44
WeekendsMove through the week, so weekends off varyEvery second weekend off, Friday to Sunday
Often used inManufacturing, healthcare, utilitiesSecurity, 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.

FAQ

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.

In RosterElf

Next week’s roster from this week’s, in one click

For when copying the sheet every week becomes the job.

A café worker beside RosterElf’s Select a roster to copy panel, with last week’s roster ready to copy

Save a week as a template and copy it forward

Any weekCopy last weekStaff app
  • 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