Staff Holiday Planner: Free Excel Leave Tracker
Free staff holiday planner for Excel: a year for up to 20 staff, statutory entitlement worked out, UK bank holidays by nation, a warning when too many are off.
Updated November 2026 · Excel · no sign-up
Without Excel: do it in medishift instead, start for free →

What's in the template
Each sheet has one job. This is how they work together.
This staff holiday planner tracks a year of annual leave for up to 20 staff in Excel. It works out each person’s statutory entitlement from the days they work, marks the bank holidays of your nation and turns a day red when more people are off than you allow.
How to fill in the template
- On the ‘Settings’ sheet, enter the year, your nation and how many staff may be off at once.
- On the ‘Team’ sheet, enter names, days worked per week and any leave carried over. Leave the entitlement blank for the statutory minimum.
- On each month, pick H, HD, S or T for a day.
- Check the ‘absent’ row for red days and the ‘Team’ sheet for what is left.
How the template calculates
Statutory minimum = 5.6 × days worked per week, at most 28 daysBank holidays = weekday bank holidays of the year × days per week ÷ 5, if they count towards leaveLeft = entitlement + carried over − bank holidays − booked days| 5.6 weeks of paid holiday a year, at most 28 days | WTR 1998 regs 13 and 13A |
| Bank holidays can count towards statutory leave | gov.uk holiday entitlement |
Limits of the template
For a small team the file is enough. This is where it reaches its limits.
- Northern Ireland has its own Working Time Regulations (2016) with the same rules under different regulation numbers.
- The planner runs on the calendar year. If your leave year starts in April, keep one file per leave year and enter what was booked before.
- Working days are Monday to Friday. For staff on irregular hours or shifts, enter the entitlement by hand.
- Requests and approvals happen outside the file; it only holds what you type in.
- One person keeps the file. Changes are not recorded.
Excel holiday planner or medishift
The planner is enough if one person types in every request. If staff should request leave themselves and see their balance, medishift does that in the app.
| Criterion | Excel template | medishift |
|---|---|---|
| Requesting leave | partly: by email or on paper, then type H | yes: request in the app, approve with one tap |
| Balance | partly: on the Team sheet, for whoever has the file | yes: every person sees their own balance |
| Bank holidays | partly: in the file to 2028 | yes: in the calendar for your location |
| Cover | partly: red day in the ‘absent’ row | yes: leave sits on the rota, gaps show where you plan |
| On the go | partly: open the file | yes: app for iOS and Android |
Holiday requests without forms
In medishift staff request leave in the app. You approve with one tap, medishift counts the days around weekends and bank holidays, and the leave is on the rota straight away.

See medishift in 30 minutes
We show you, using your own team, how rota, time tracking and leave work together without Excel. Pick a time that suits you.
- 30 minutes
- Via Google Meet
- Free and without obligation
1. Pick a slot
Wednesday 18 November
FAQ: Staff holiday planner
Almost all workers are entitled to 5.6 weeks of paid holiday a year. The planner multiplies 5.6 by the days a person works per week: 28 days for five days, 16.8 days for three. The statutory minimum never goes above 28 days.
They can. An employer may include bank holidays in the statutory entitlement. Set ‘Bank holidays count towards leave’ to yes and the weekday bank holidays of the year come off each person’s entitlement, pro rata for part-time staff. Set it to no if bank holidays are on top.
Yes. The file holds the bank holidays from gov.uk for England and Wales, Scotland and Northern Ireland from 2026 to 2028, including substitute days and one-off days such as Scotland’s bank holiday for the 2026 World Cup.
Yes. Type it in the ‘Entitlement’ column on the ‘Team’ sheet. A blank cell uses the statutory minimum.
You set how many staff may be off at once on the ‘Settings’ sheet. On any working day above that number, the ‘absent’ row of the month turns red.
Yes. The file uses only functions that Excel and Google Sheets both know, so the drop-downs and totals work after you upload it to Google Drive.
Related templates

Holiday Request Form: Free Template, Excel & PDF
Free holiday request form as Excel and PDF: days counted without weekends and UK bank holidays, a notice check under the Working Time Regulations and sign-off.

Weekly Work Schedule Template: Free Excel & PDF
Free weekly work schedule template for Excel and as a printable PDF: start and finish times, hours against the contract, rest checks and a monthly plan.

Timesheet Template with Overtime: Excel & PDF
Free timesheet template for Excel and as a printable PDF: four weeks for one person, with weekly overtime, pay at your overtime rate and break and rest checks.




