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.

Next month you’ll redraw 31 columns and re-enter everyone’s leave.
In RosterElf you import your staff from a CSV once, save the week as a rota template and publish it to everyone’s phone. Approved hours go to Xero UK or a CSV.
Your download has started.
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
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:
| Nation | Bank holidays a year | Differs from England and Wales |
|---|---|---|
| England and Wales | 8 | - |
| Scotland | 9 | 2 January and St Andrew’s Day; the summer bank holiday is the first Monday in August; no Easter Monday |
| Northern Ireland | 10 | St 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.
More rota templates
Bank holidays from GOV.UK: UK bank holidays; holiday rules from GOV.UK: holiday entitlement. The file counts shifts only; it does not work out pay.
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.
Next week’s rota 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 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