Holidays for 2019 are still a long way off, but some companies need to plan for the long term to avoid understaffing. For this case, I have updated the vacation planner 2018 to 2019.
Update: There is a new planner for 2020.
Unlike the last vacation plan, this time there are three instead of two worksheets. Two for the year 2019 and one for the first six months of 2020. Thus, the holidays for the New Year or New Year can also be recorded immediately.
On the first two worksheets you will find 6 months each with the individual days of the week and room for 7 employees. You can print the sheets and mark with color or characters (for example, a cross or a dash) on which days which employee is on vacation.
In the holiday calendar, make a color mark directly in Excel – how it works
If you prefer to do this with Excel, you can give the corresponding cells a background color: To create a background color, simply mark the corresponding cells and then click on the color bucket in the Excel toolbar. Compare also with the picture below ..
Microsoft has written a little tutorial for this:
For those who are unfamiliar with Excel, I have also created the planner as a PDF. Just download, print and fill in the same way ..
Screenshots from the excel-template vacation planner 2019 and parts of 2020
Download the excel-template vacation-planner 2019 for free
Here are the files you need for the purpose you want: Excel-sheets for managing the holidays of your team with your excel-software or a blank pdf for printing it and mark it with a pen.
- Vacationplanner 2019 excel-sheet (xlsx)
- Vacationplanner 2019 excel-template (xltx)
- Vacationplanner 2019 (PDF)
- All files in a zip
New version with fixed 29th of February 2020 🙂 :
Another free calendar for planning holiday of your staff is here:
http://www.reviewmylife.co.uk/blog/2017/01/17/2018-and-2019-staff-holiday-excel-planner-and-one-page-excel-calendar/
For year 2020 there is 29 days in February. Please make a correction.
Hi Ignac,
thanks so much for your hint!
I’ll correct it soon..
Cheers, Philipp
This was really useful. Thanks for helping all everyone out with these great calendars 🙂