Guide

Holiday Rota: A Free 2027 Planner and the Rules That Stop Clashes

By Ben Hardy9 min read
An open monthly paper planner with handwritten notes on a desk

A holiday rota decides who can be off when, before anyone asks. Without one, leave is first come first served, the same three people get the school holidays every year, and you find out you're short-staffed when two requests land for the same week. This guide gives you a free 2027 staff holiday planner to download, the booking rules that stop clashes, and the UK notice periods that decide what you can refuse.

A holiday rota sits on top of your shift rota: plan leave first, then build the weeks around it. If you're starting from scratch, our guide to how to make a staff rota covers the shifts side.

Free download

Staff holiday planner 2027 (Excel)

  • Every day of 2027 across the top, one row per person, 25 rows
  • England and Wales bank holidays marked; Scotland and Northern Ireland on a second sheet
  • Allowance, carried over, taken and remaining, worked out for you
  • A cover check that flags any day with more people off than you allow
  • A priority log for sharing school holidays and Christmas fairly

Free, no sign-up. Opens in Excel or Google Sheets (upload it to Drive and open with Sheets).

Rather plan it in your browser? The free staff holiday planneris the same wall chart online, with each person's days left worked out as you click.

What Is a Holiday Rota?

A holiday rota has two parts. The first is the calendar: everyone's approved leave for the year, in one place, so you can see at a glance who is off on any day. The second is the rules: how many people can be off at once, how far ahead people must book, and who gets priority for the weeks everyone wants.

Most clashes come from missing rules, not a missing calendar. If two people ask for the same August week and nothing says who wins, you end up deciding on the spot, and whoever loses assumes favouritism.

UK Bank Holidays 2027

These are the dates published on GOV.UK. Christmas Day 2027 falls on a Saturday and Boxing Day on a Sunday, so the bank holidays move to Monday 27 and Tuesday 28 December.

DateEngland & WalesScotlandNorthern Ireland
Fri 1 JanNew Year's DayNew Year's DayNew Year's Day
Mon 4 Jan—2nd January (substitute)—
Wed 17 Mar——St Patrick's Day
Fri 26 MarGood FridayGood FridayGood Friday
Mon 29 MarEaster Monday—Easter Monday
Mon 3 MayEarly MayEarly MayEarly May
Mon 31 MaySpringSpringSpring
Mon 12 Jul——Battle of the Boyne
Mon 2 Aug—Summer—
Mon 30 AugSummer—Summer
Tue 30 Nov—St Andrew's Day—
Mon 27 DecChristmas Day (substitute)Christmas Day (substitute)Christmas Day (substitute)
Tue 28 DecBoxing Day (substitute)Boxing Day (substitute)Boxing Day (substitute)

Planning the end of this year instead? Our Christmas rota guide has the 2026 festive dates and a timeline for allocating them.

Holiday Rota Rules That Prevent Clashes

Six rules cover almost every clash. Write them down, share them before the leave year starts, and apply them the same way to everyone.

1. Set how many people can be off at once

Work out the cover you need, then the most people who can be away on the same day. Set it by team or role, not just headcount: one chef off out of three is different from one of two. In the planner this is cell D2, and the cover row shows CHECK on any day you'd break it.

2. Decide who books first

For ordinary weeks, first come first served is fine. For the weeks everyone wants (summer school holidays, Easter, Christmas, half terms) open a booking window, say January for the summer, and decide between clashing requests by a rule you publish, not by who asked first.

3. Rotate the popular weeks

Keep a simple log of who had the most-wanted weeks this year. Next year, the person with the lowest score chooses first. The planner's Priority log sheet does the adding up. It is the only thing that stops the same people getting August every year, and the only evidence you'll have when someone asks why they didn't get it.

4. Put any blackout periods in writing

GOV.UK says employers can restrict when leave is taken, "for example at certain busy periods", but the restriction should be set out in the employment contract, and you can't stop people taking their leave altogether. If December is off-limits in your shop, say so in the contract and the holiday policy.

5. Set a use-it-or-lose-it deadline

Remind staff with days left in good time before the leave year ends. Otherwise everyone with leave to lose asks for the final weeks of the year. Our guide to carrying over annual leave covers what you must allow.

6. Pro-rate part-timers properly

Part-timers get 5.6 times the days they work each week (3 days a week is 16.8 days) and bank holidays need the same care. Use our pro rata holiday calculator for starters, leavers and part-timers, and put the result in the planner's allowance column.

UK Notice Rules for Booking Holiday

Unless your contracts say otherwise, these are the defaults set out on GOV.UK:

WhoRuleExample: one week (5 days)
Worker asking for leaveAt least twice the leave, plus 1 day11 days' notice
Employer refusing itAs much notice as the leave, plus 1 day6 days' notice
Employer requiring leave on set datesAt least twice the leave10 days' notice

Those minimums are short. Most holiday policies ask for more notice for anything over a week, and a booking window for the popular periods. Whatever you choose, put it in the policy so nobody is surprised. The last row is how a Christmas shutdown works: we cover it, and the opposite case, in making employees take annual leave.

Bank Holidays on the Holiday Rota

“The app is simple to use, reliable, and makes managing holidays, absences, and staff records straightforward. The system has saved us a significant amount of administration time.”

CLI ManchesterJordan Ingoe, CLI Manchester

Common Holiday Rota Mistakes

When two requests do collide, our guide to clashing holiday requests covers how to decide and how to say no well.

Watch: holiday and the rota in one app, out of the group chat (1:44)
Try TimeTally freeFree for 14 days. No card needed.

How TimeTally Helps With the Holiday Rota

A spreadsheet works for a small team that books a few weeks a year. Once requests come in by text, email and in passing, TimeTally keeps leave and the rota in one place:

One honest limit: TimeTally warns you when approving a request would double-book that person, but it doesn't enforce a team-wide "most people off at once" rule. Check the team calendar before approving the popular weeks. It costs £3 per employee per month; see the staff holiday tracker and leave tracking software pages for more.

TimeTallyTimeTally

Holiday Requests and the Rota in One Place

Staff ask from their phone, you approve, and the leave shows on the team calendar and the rota.

Leave requests from any phone
Leave shown on the rota
£3 per employee per month

Key Takeaways

Frequently Asked Questions

What is a holiday rota?

A holiday rota is the plan for who can be off when: a yearly calendar of everyone's approved leave, plus the rules for booking it, such as how many people can be off at once, who gets priority for school holidays and Christmas, and how much notice staff must give.

What is a rotating holiday?

A rotating holiday system shares the most popular periods in turn. Whoever had the summer school holidays or Christmas off this year goes to the back of the queue for them next year, so the same people don't get the best weeks every year.

Where can I find a staff holiday calendar for 2027?

Download the free 2027 staff holiday planner on this page. It has every day of 2027 across the top, England and Wales bank holidays already marked, the Scotland and Northern Ireland dates on a second sheet, and allowance, taken and remaining columns that work themselves out. GOV.UK publishes the official bank holiday dates.

Is 4 February 2026 a bank holiday?

No. There is no bank holiday in February anywhere in the UK. In 2026, England and Wales went from New Year's Day to Good Friday on 3 April; Northern Ireland had St Patrick's Day on 17 March in between, and Scotland had 2 January.

What is pro rata holiday?

Pro rata holiday is the statutory 5.6 weeks scaled to the days someone works. A part-timer on 3 days a week gets 3 × 5.6 = 16.8 days a year; someone who starts or leaves part-way through the leave year gets the share for the part they worked. Our pro rata holiday calculator does the sum.

How much notice do staff have to give to book holiday?

By default, at least twice as long as the leave plus one day: a week (5 days) off needs 11 days' notice. You can refuse with as much notice as the leave plus one day. Your contracts can set different rules, and most employers ask for more notice for long or popular periods.

Sources