Vacationplanner 2019

Last Updated on

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:

https://support.office.com/en-us/article/add-or-change-the-background-color-of-cells-ac10f131-b847-428f-b656-d65375fb815e

Change the background of cells for vacation

Change the background of cells for vacation



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

Vacation planner 2019 Excel

Vacation planner 2019

Vacation planner 2019 with the first 6 Month of 2020

Vacation planner 2019 with the first 6 Month of 2020

Worksheets for planning holidays 2019

Worksheets for planning holidays 2019

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.

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/

 

3 thoughts on “Vacationplanner 2019

  1. Ryan

    This was really useful. Thanks for helping all everyone out with these great calendars 🙂

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *