Staff Leave Planner for Excel — UK Bank Holidays Auto-Calculated, Any Holiday Year, Up to 25 Staff

Stop rebuilding your leave planner every January.

Most holiday trackers die at the end of the year: bank holidays hard-typed, everyone assumed full-time, calendar welded to 1st January. This one was built inside a real multi-office professional services firm — and built to last.

Set any holiday year. Seriously, any.

Your leave year starts 1st June? 6th April? Enter one date and the full 12-month calendar rebuilds around it — including bank holidays for both calendar years your leave year spans.

Bank holidays that update themselves. Forever.

Every England & Wales bank holiday is calculated by formula — Easter included, weekend substitute days included. Change the year, they move. No internet connection, no re-purchase, no fiddling. It'll still be right in 2035.

Part-time and flexible workers, handled properly.

Set each employee's Mon–Fri working pattern and their non-working days shade out automatically on the chart. Someone dropping from five days to four in March, then to three in September? Two mid-year pattern changes per person are built in.

At-a-glance colour coding.

Green for holiday, red for sickness, blue for TOIL, amber for bank holidays and your own closure days, grey for weekends and non-working days. One glance at the wall chart tells you who's in.

Zero-maintenance totals.

Holiday used, days remaining (including carry-over), sickness days and TOIL balance all calculate live for each of up to 25 employees. The formulas are protected so nobody can break them by accident — and there's no password, so you're never locked out of your own file.

What you get

• One .xlsx file — instant download
• 12-month visual planner, 25 employee rows
• Dropdown leave codes (full day, half day, sickness ×2, TOIL)
• Working patterns tab with dual mid-year changes
• Settings tab: year start date, auto bank holidays, custom closure days
• Full Instructions tab — set up in under 10 minutes
• No macros. No security warnings. Works on locked-down office machines.
  
  

Requirements: Microsoft Excel 2016+ (Windows/Mac) or Microsoft 365. Opens in LibreOffice. Not for Google Sheets.

Licence: single business use. Questions or issues? Message me — I built this and I'll stand behind it.