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!!
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.






Comments are closed