Free template· UK, Excel, opens in Google Sheets

Free monthly rota template (Excel)

A monthly rota shows the whole month on one sheet: one row per person and 31 narrow day columns, with a single-letter code in each day such as D, E, N, OFF, AL or BH. This template counts each person’s shifts for the month, so leave clashes and bank holiday gaps are visible weeks ahead.

rosterelf-uk-monthly-staff-rota.xlsx
The monthly rota template filled in for December: each person’s role with day, evening and night codes, days off and annual leave marked AL

File checked No signup

The download

What’s in the file

  • Days 1 to 31 across one sheet, 16 staff rows down
  • A Shifts column counts the days each person works, by formula
  • Shift codes for days, evenings, nights, holiday and bank holidays
  • An Instructions tab with working time reminders
Download Excel (.xlsx)
Only on this page

Bank holidays are not the same across the UK

A monthly view is where bank holidays get planned, so mark them BH. The four nations do not share a calendar:

NationBank holidays a yearDiffers from England and Wales
England and Wales8-
Scotland92 January and St Andrew’s Day; the summer bank holiday is the first Monday in August; no Easter Monday
Northern Ireland10St Patrick’s Day (17 March) and the Battle of the Boyne (12 July)

There is no automatic right to bank holidays off. Whether they are paid, extra, or part of the 5.6 weeks of statutory holiday is contractual. When Christmas or Boxing Day falls on a weekend, a substitute weekday becomes the bank holiday, as 28 December does in 2026. See our bank holiday guide.

FAQ

Monthly rota FAQ

  • Put names down the left and 31 narrow day columns across the top, then use single-letter shift codes rather than times so the month fits on the page. Add a shift count (a COUNTIF for each working code) at the end of each row and freeze the first two columns. The template above is already set up this way.

  • Delete or hide columns 29 to 31 as needed. The shift counts still work because they count across the whole range.

  • Codes. At 31 columns wide there is no room for “09:00–17:00” in every cell. Define D, E and N on the Instructions tab and use the weekly rota template when you need exact times.

  • Agree leave before the rota is written, not after. A monthly grid makes clashes obvious: five people with AL in the same column is a problem you want to see in advance. Our holiday entitlement guide covers how much leave people are owed.

  • As far ahead as you can manage. There is no general statutory minimum notice today, though the Employment Rights Act 2025 will introduce a right to reasonable notice of shifts, expected in 2027. See our rota laws guide.

In RosterElf

Next week’s rota 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 rota as a reusable template
  • Copy last week’s rota instantly
  • Clone individual shifts across days
  • Staff see their shifts on the iPhone and Android app