Holiday planner template
for Excel & PDF
With this calendar view template available in Excel or PDF, you can plan holidays in a team. For the current calendar year, it allows you to plan the holiday of up to 20 employees in parallel. The total holiday entitlement, the entitlement taken and the remaining holiday are calculated automatically.
Use cases holiday planning template
Cross-team and transparent holiday planning
Comply with and track holiday entitlements
Control capacity utilisation and availability
- Only enter the remaining holiday from the previous year and the holiday entitlement from this year in the front section of the table
- Mark the days on which your employees have submitted holiday with an X - No differentiation between weekends/public holidays and weekdays
- No differentiation between weekends/public holidays and weekdays - Front columns for leave taken and remaining leave are calculated and filled in real time
- Front columns for leave taken and remaining leave are calculated and filled in real time - Only public holidays, which are standardised for all German federal states
- Deviating public holidays must be marked themselves, or please note that no X is placed in these columns
FAQ's - Frequently asked questions about the holiday planner:
Why do I need a holiday planning template in Excel or PDF?
The available calendar view allows you to plan holidays for the entire team (with up to 20 employees) in this template. The individual remaining leave days are calculated automatically using stored formulas.
How can I use the template for my team holiday planning?
Enter the remaining holiday from the previous year and the holiday entitlement for the current year in the front section of the table. Mark the days on which employees have requested leave with an X, without differentiating between weekends, public holidays and weekdays. The front columns for leave taken and remaining leave are automatically calculated in real time.
What advantages do I have with the holiday planner in Excel or PDF?
The holiday planning template provides a transparent & cross-team overview. This allows you to keep an eye on the team's workload and to comply with and easily track holiday entitlements.
Can I also plan my holidays in ZEP?
Yes! In ZEP, you and your team can plan your holidays together digitally. It's quick and easy to do. Thanks to the graphical display, every team member can immediately see who is absent and when.
Fill in and approve holiday requests
Simple template for recording hours
Excel list for recording working hours
all templates ➔
If you don't want to leave holiday planning to chance, you can also rely on ZEP. You can use ZEP to plan holidays digitally as a team and keep an eye on who is absent and when. With the clear visualisations in ZEP, every colleague always has an overview. In both small and large teams.