Free Excel Staff Holiday Planner

Staff holiday and annual leave planner

This was our first ever give away tool, a handy one for anyone who is managing a team and wants to track and plan staff holidays.

Now downloaded over 40k times!! 👍

Screenshot of the holiday tracker tool

Absolutely love this planner.  Used it last year and it was a massive time saver.  Would wholeheartedly recommend it to anyone who needs to manage staff leave.

Michelle Maddocks

I have to say I love the holiday/sickness tracker tool!  Its made a painful time-consuming job unbelievably simple, so thank you. Honestly, I can’t tell you how many problems this has solved within the Business I work for!!

Claire Rathmell

I downloaded the updated spreadsheet and I absolutely love the new feature. Great Job!!!

Ro Patino

Great tool and very easy to use

Sid Martin

This has been an amazing help to track absences in our business


I’ve been using the holiday planner and its been a fantastic tool for us. 

Gillian Flitton-Rapley

Thank you so much for your Team Holiday Spreadsheet … this is going to prove very, very useful!


Thank you for providing this amazing Excel that actually really simplifies my task for my team and department.

Majid Sultan

I have download your holiday tracker 2016 and 2017 for our department use.  It is very simple and fantastic.


The holiday tracker has enabled me to be able to count the days of each employee and be able to send them a report on the leave days balance. After I had implemented the tool I am now able to inform each staff promptly and frankly, it has lessened the paper workload and calculations.


How to use it…

This short video takes you through how to set up and use the tracker…

Once you’ve mastered the basics, these top tips will help you get even more from it.

System requirements:

  • Excel 2007+
  • Windows
  • Macros enabled

Features of the staff holiday planner:

  • Track up to 1000 employees – Just enter their name in column A and a new row will appear.
  • Compare the amount of annual leave taken by staff against their allocation for the year – Enter their allocation for the year and the tool will track how many days they have left. You can highlight full, half or public holidays using the dialog box provided. You can also mark training days, provisional holidays, free (lieu) days, sick days or other days.
  • Works for 2019, 2020, 2021… any year at all. Simply tell it your leave year start date when you first open the tool and it will track holidays against this period.
  • Option to enter staff leave as days (and half days) or as hours.
  • Multi-locale support – The tool has been tested to work with different date formats
  • Weekends optional – Show or hide weekends as required, depending on whether your team works weekends. You can specify which days to use – particularly useful in UAE where Friday is part of the weekend.
  • Working days calculation – Easily show how many working days are available by simply selecting the range of days you want to add, any holidays or public holidays will be deducted from the total. Sick days are also calculated.
  • Looks pretty and is super easy to use.
  • It’s free!

If you have a request for new functionality or have found a bug… then please report it to us here.

Enjoy 🙂

We also recommend LeaveDates as an online alternative for managing staff holidays.