Free Staff Holiday Planner Template (Excel + PDF)
This free staff holiday planner template is an annual leave planner in Excel that does the counting for you. Add your team once, and it works out each person’s UK holiday entitlement, adds up the days booked month by month, shows what’s left and turns pink when too many people are off on the same day. There’s a printable PDF for the staff room wall too.

What’s in the free staff holiday planner template
Built for hospitality, where people work different days, part-time is normal and summer is when everyone wants the same fortnight.
- One allowance tab for the whole team. Name, role, days worked per week, extra contract days and days carried over. Room for 15 people.
- UK holiday entitlement worked out for you. 5.6 weeks pro rata to the days someone works, capped at 28 days.
- 12 month tabs. Type a code in the day: H for holiday, HD for a half day, S for sick, U for unpaid, O for other. Names fill in from the allowance tab.
- Booked and remaining, live. Each person’s days per month, total booked and days left update as you plan. A negative balance turns pink.
- A clash check. The Off row counts who’s away each day and turns pink above your limit, so you spot the summer pile-up before you approve it.
- Weekends and bank holidays shaded. 2027 bank holidays for England and Wales are in, ready to edit for Scotland or Northern Ireland.
- An irregular-hours tab. For zero-hours and casual staff, holiday builds up in hours at 12.07%.
- A printable PDF. The allowance sheet and a page per month, dated for 2027, to fill in by hand.
How to use the annual leave planner in Excel
- Check Settings. The first day of your leave year, the bank holidays and the most people who can be off on one day.
- Add your team on the allowance tab. Type the days each person works per week. Statutory holiday calculates itself.
- Add extra contract days and carry-over. If your contracts give more than the legal minimum, put the difference in Extra days.
- Book holiday on the month tabs. Type H in each day someone’s off, or pick it from the drop-down. Half days are HD.
- Watch the Off row. Pink means more people are away than you allow. Sort it before you say yes.
- Track irregular hours separately. Set those staff to Irregular, then type their hours per month on the Irregular hours tab.

UK holiday entitlement: the rules the planner uses
The template follows the statutory rules. Contracts can give more, never less.
| Rule | What it means | Source |
|---|---|---|
| 5.6 weeks a year | Almost all workers, including part-time, get 5.6 weeks paid holiday | gov.uk |
| Capped at 28 days | A 6-day week still gets 28 days of statutory holiday | gov.uk |
| Part-time pro rata | Days worked per week × 5.6 | gov.uk |
| Bank holidays | Don’t have to be given as paid leave, but can count towards the 5.6 weeks | gov.uk |
| Irregular hours and part-year workers | Accrue 12.07% of hours worked in each pay period, for leave years from 1 April 2024. Rolled-up holiday pay is allowed for these workers | gov.uk |
| Notice | Workers give twice the length of the leave plus one day. Employers refuse with notice as long as the leave plus one day | gov.uk |
The legal detail sits in the Working Time Regulations 1998, regulations 13, 13A and 15B. This is a summary, not legal advice.
How to calculate holiday entitlement
Fixed days. Days worked per week × 5.6, up to 28.
| Days per week | Statutory holiday |
|---|---|
| 5 | 28 days |
| 4 | 22.4 days |
| 3 | 16.8 days |
| 2 | 11.2 days |
Irregular hours. Hours worked in the pay period × 12.07%. A runner on a zero-hours contract who works 80 hours in a month accrues 9.66 hours of holiday that month. 12.07% is 5.6 weeks divided by the 46.4 weeks left to work in a year.
Joiners and leavers. They get a share for the part of the year they work. Adjust their Statutory days on the allowance tab.
Holiday planning tips for hospitality teams
- Set a cut-off for peak requests. For example, summer holiday booked by the end of March and Christmas by the end of September. First come, first served beats arguments in July.
- Agree who gets priority. Rotating priority for the school holidays, year on year, is fairer than whoever asks loudest.
- Set a limit per section, not just per site. Two people off in the kitchen hurts more than two off front of house. Use one copy per team if you need to.
- Remind people in autumn. Somebody always reaches November with eight days left. Spreading them across quieter weeks beats a December with half the team away.
- Mark sick days too. A pattern of short absences is worth a conversation. Our guide to absenteeism has more, and the Bradford Factor calculator scores the pattern.
- Plan the rota with holiday in view. Holiday that only lives in a spreadsheet gets missed on the rota. Pair it with our free staff rota template.
When the spreadsheet stops scaling at 5+ sites
A holiday spreadsheet works for one site and one manager. At five sites it’s five files, nobody can see the group picture, requests arrive by text and the rota gets planned without them. Someone books a week off that was already approved for two others, and nobody finds out until the Monday.
That’s what the All Gravy holiday planner is for:
- Requests from the app. Staff ask for holiday on their phone and see their balance before they ask.
- Approval in one place. Managers approve, and the person knows straight away.
- Holiday next to the rota. Approved holiday shows up while you plan the week, along with who’s unavailable, so you plan around it.
- The same app as everything else. Holiday sits next to shifts, chat, training and handbooks. Nothing extra to roll out.
It’s part of All Gravy Scheduling, launching now. Book a demo to see it with your own team.
Frequently asked questions
Is the staff holiday planner template really free?
Yes. Download the Excel file and the printable PDF straight from the page. No email, no sign-up. Use it for as many sites and years as you like.
Does the holiday planner work in Google Sheets?
Yes. In Google Sheets go to File, Import and upload the .xlsx. The formulas, colours, drop-downs and clash check come with it. It also opens in Excel and LibreOffice.
How many days holiday are staff entitled to in the UK?
Almost all workers are entitled to 5.6 weeks paid holiday a year. Someone working 5 days a week gets 28 days. Statutory holiday is capped at 28 days, so a 6-day week also gets 28. Employers can include bank holidays in the 5.6 weeks. Source: gov.uk.
How do you calculate holiday for part-time staff?
Multiply the days they work each week by 5.6. Three days a week gives 16.8 days, four days gives 22.4. The template does this for you on the allowance tab.
How is holiday worked out for zero-hours or irregular-hours staff?
For leave years starting on or after 1 April 2024, irregular-hours and part-year workers build up holiday at 12.07% of the hours they work in each pay period. Someone who works 80 hours in a month accrues 9.66 hours of holiday. The template has a tab for this.
Can an employer refuse a holiday request?
Yes, but they have to give notice at least as long as the leave asked for, plus one day: 11 days notice to refuse 10 days off. Workers must ask with notice of at least twice the length of the leave, plus one day, unless the contract says otherwise. Source: gov.uk.