Cookie preferences

Analytics and marketing cookies are on unless you switch them off here. Read the cookie policy.

Strictly necessary Always on

Needed for the site to work, such as security and remembering your cookie choice.

Help us understand which pages are useful and which companies visit our site, so we can improve it.

Used to measure our adverts and show relevant adverts on other sites.

A free staff holiday planner for 2027, with balances.

This staff holiday planner is an Excel file for the 2027 leave year. Mark holiday, sickness and other leave on a calendar for the whole team, and each person’s days taken and days left work themselves out.

Last updated November 2026

Staff holiday planner 2027

  • A calendar for every day of 2027, for up to 30 people
  • Weekends and England and Wales bank holidays shaded
  • Statutory minimum, allowance, carry-over, days taken and days left for each person
  • Half days, sickness and other leave marked in their own colours
  • Every 2027 bank holiday for England and Wales, Scotland and Northern Ireland
Download the holiday planner

Excel file, 46 KB. Free, no form to fill in.

How to use the holiday planner as a holiday tracker

  1. On the Staff sheet, list each person, their team and the days they work a week.
  2. Check their allowance for the year and add any days carried over.
  3. On the planner, mark each day off with H for holiday, ½ for half a day, S for sick or O for other leave.
  4. Days taken and days left update as you go. A negative balance shows in red.

How much holiday staff are entitled to

Almost all workers are entitled to 5.6 weeks of paid holiday a year. For someone working 5 days a week that is 28 days, and statutory paid holiday is capped at 28 days. Employers can include bank holidays in the 5.6 weeks. Source: GOV.UK holiday entitlement.

The planner works out the statutory minimum from the days each person works. For hours, irregular hours or someone joining part-way through the year, use the holiday calculator or the annual leave calculator. Bank holiday dates for every nation are in our UK bank holidays guide.

Holiday tracking without the spreadsheet

In Givver, the leave engine applies your leave policies, accruals, carry-over and regional bank holidays, so balances are worked out for you. Employees request leave and see their balance in the Givver app, and rotas show who is off.

See leave and absence →   See rota software →   Talk to sales →

Questions about the staff holiday planner 2027

What is a staff holiday planner?

A staff holiday planner is a calendar of who is off and when, with each person’s holiday allowance and how much they have left. This one is an Excel file for the 2027 leave year.

Does the holiday planner include bank holidays?

Yes. England and Wales bank holidays for 2027 are shaded on the planner, and the dates for Scotland and Northern Ireland are on their own sheet, all taken from GOV.UK.

How does the planner work out holiday allowance?

It starts at the statutory minimum of 5.6 weeks of the days each person works, capped at 28 days. You can change the allowance if your policy gives more.

Can I use it as a leave planner or holiday tracker?

Yes. The planner shows who is off on each day of 2027, and tracks each person’s days taken and days left as you mark leave.

Is the holiday planner free?

Yes. Download it and use it as often as you like. There is no form to fill in.

More free templates and tools

This template is general guidance, not legal advice. Check it against GOV.UK and adapt it to your business.

Rotas, leave and contracts on one employee record.

See how Givver would work for your team.

Talk to sales