-
Excel workbook preview
Leave, Absence and Time Tracking
Annual Leave Planner (team calendar)
3 downloads per free account, no card needed.
Who this is for
A team leader or HR administrator who has overlapping Christmas leave requests and needs to see cover and balances before approving any of them.
What is inside
- Month calendar for 20 people: X approved, P pending, BH bank holiday, weekends shaded
- People off per day counted and turned red above your limit
- Leave Bookings with 11 sample bookings; working days skip weekends and bank holidays
- Entitlement sheet for 10 people with approved, pending and remaining days
- England and Wales bank holidays for 2026 and 2027 from GOV.UK
- Change the month in one cell to plan any month of the year
How to use it: List your team on the Entitlement sheet, add every request to Leave Bookings with its status, and pick the month to view in the calendar.
Files & formats
- XLSXannual-leave-planner-template.xlsx27 KB
Opens in Microsoft Word or Excel, Google Docs or Sheets and LibreOffice. Delivered instantly from your browser.
Free downloads & full access
Every account gets 3 free downloads. Re-downloading a template you already have does not count. This template on its own is $17.99, and buying it keeps your free downloads for something else. Full access is a one-time $249 for all 300 templates, for life.
Bought with a different email? Open your account and enter your order number.
Licence
Use and adapt the document inside your own organisation or for your own clients. Do not resell or republish the templates themselves.


