Holiday planner 2023 (DE, CH, AT)

I made an Excel template for planning holidays between colleagues.

The template is not suitable for planning holidays with the colleagues together, but for checking who is available or not in the department.

Here is screenshot of it:

How does it work?

Working with the template is very easy.

You just have to:

  1. Go to the "Dateneingabe" (you guessed it: it means data input)
  2. Insert the info of your colleagues and their holiday desires
  3. Select your country and region under "Feiertage".
  4. And the sheet "Urlaubsplan" will get all the work done!

⚠️ The worksheet "Urlaubsplan" is actually for visualisation (and it not intended for manipulation)

The national holidays are as well integrated in the template. You can choose one of the available countries (Germany - DE , Switzerland - CH or Austria -AT) and the national holidays will be calculated automatically.

If you want to deactivate the weekends or the national holidays just remove the "x" (sheet "Urlaubsplan"):

And voilΓ‘:

Print it

You can print in a nice format!


If you are interested, you can get it here:

Get the template

πŸ“Š Create a modern CV
Create a modern CV

Create a modern CV to impress recruiters