• Preview of Annual Leave Planner (team calendar)Excel workbook preview

Leave, Absence and Time Tracking

Annual Leave Planner (team calendar)

$17.99 Free XLSX
Excel workbook · 27 KB

3 downloads per free account, no card needed.

Need more than 3? Get all 300 templates for $249 One payment, lifetime access, including every template added later.

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.