Free Excel Staff Holiday Planner

Staff holiday and annual leave planner

This was our first-ever giveaway tool, a must for anyone who manages a team and needs to track and plan staff holidays.

Now downloaded over 40k times!!

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

Jody

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!

Caroline

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.

Orsha

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.

Catherine

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 – 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. Using the dialog box provided, you can highlight full, half, or public holidays. You can also mark training days, provisional holidays, free (lieu) days, sick days, or other days.
It works for 2025, 2026, or any year at all. When you first open the tool, simply tell it your leave year start date, and it will track holidays against this period.
Option to enter staff leave as days (and half days) or hours.
Multi-locale support – The tool has been tested to work with different date formats
Weekends are optional. You can Show or hide weekends as required, depending on whether your team works weekends. You can specify which days to use—particularly useful in the 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.
It looks pretty and is super easy to use.
It’s free!

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

Enjoy 🙂

To download the holiday planner, please enter your details below.

This will subscribe you to our ‘annual leave’ mailing list. We will immediately send you an email with the download link. If you don’t receive it within 5 minutes, please check your spam folder.

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