Excel spreadsheetNew

Staff Holiday Planner

Keep track of everyone's holiday in one place

List your staff and the days a week they work, and the planner works out the statutory minimum holiday (5.6 weeks, up to 28 days). Log each booking and it counts the working days, skipping weekends and bank holidays, then shows the days taken and left for everyone.

Freefree account needed · no card
Sign up & download free

Create a free account on our client portal (or sign in) to download. No card details needed. How it works

  • Excel .xlsx
  • Google Sheets
  • Numbers
  • LibreOffice

In the download (18 KB zip)

  • Staff-Holiday-Planner.xlsx

What's included

  • Statutory minimum worked out from days a week (5.6 weeks, capped at 28 days)
  • Your own allowance and days carried over
  • Leave log that counts working days, skipping weekends and bank holidays
  • Annual leave, sickness, unpaid and other leave
  • Days taken, days left and sick days for each person
  • Year view of annual leave by month
  • England & Wales bank holidays for 2026 and 2027, ready to edit
  • Room for 30 staff and 500 bookings

Perfect for

  • Small businesses with a handful of staff
  • Shops, cafés, salons and trades
  • Office managers
  • Replacing the holiday wall chart

Questions

Is it really free?

Yes. You need a free account on our client portal to download it, and that's all. No card details, no subscription.

Why do I need an account?

The account is where your downloads live, so you can download the file again at any time, and it's the same account you'd use for any of our paid templates.

Can I use it in my business?

Yes, for your own business or organisation. Please don't share or resell the blank template. See the licence for details.

How do I get the file?

Press Sign up & download free, create a free account on our client portal (or sign in) and complete the free checkout. No card is needed. The download appears under My downloads straight away.

Want more?

Our full spreadsheets and document packs go further, from £2.99, or get several together in a bundle.

Get Staff Holiday Planner · Free

You might also like

Excel spreadsheetFree

Simple Monthly Budget

A one-page budget: what you plan to earn and spend, what actually happened, and what's left over. Overspends turn red, and a chart compares budget…

Excel spreadsheetFree

Weekly Timesheet

Enter start and finish times and unpaid breaks for each day. Hours, overtime after your chosen limit and an estimated gross pay figure work…