medishift

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 →

staff-holiday-planner.xlsx
Staff Holiday Planner: Free Excel Leave Tracker

What's in the template

Each sheet has one job. This is how they work together.

staff-holiday-planner.xlsx · April
  1. Ansicht des Blatts „April“

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

  1. On the ‘Settings’ sheet, enter the year, your nation and how many staff may be off at once.
  2. On the ‘Team’ sheet, enter names, days worked per week and any leave carried over. Leave the entitlement blank for the statutory minimum.
  3. On each month, pick H, HD, S or T for a day.
  4. 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 daysWTR 1998 regs 13 and 13A
Bank holidays can count towards statutory leavegov.uk holiday entitlement

Holiday entitlement in the UK, explained →

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.

CriterionExcel templatemedishift
Requesting leavepartly: by email or on paper, then type Hyes: request in the app, approve with one tap
Balancepartly: on the Team sheet, for whoever has the fileyes: every person sees their own balance
Bank holidayspartly: in the file to 2028yes: in the calendar for your location
Coverpartly: red day in the ‘absent’ rowyes: leave sits on the rota, gaps show where you plan
On the gopartly: open the fileyes: 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.

    More about the staff holiday booking system
    Absence calendar in medishift: holiday, sickness and training for each person across the month

    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

    November 2026
    MonTueWedThuFriSatSun

    Wednesday 18 November

    Loading available slots …

    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.