Posts Tagged ‘vacation’

2022 staff holiday calendar – free excel spreadsheet

Sunday, October 31st, 2021

It is getting close to 2022 so your staff might be starting to request holiday and time off for 2022. Following on from my 2021 staff holiday planner, is my free spreadsheet for 2022.

2022 staff holiday planner excel spreadsheet

It can be very useful to visualise everyone’s holiday/vacation on a single spreadsheet as then you can make sure that time offs between staff are appropriately distributed. Equally important is to ensure that everyone takes their full holiday allowance!

This spreadsheet can also be used for tracking training, unpaid leave, working from home and sick days. You could add additional formulas to track these other types of leave if they are important to you.

As usual the spreadsheet has the days of the year running from left to right, with a separate row for each member of staff. There are some in built formulas for calculating remaining holiday. You’ll see the formula works by counting cells with either ‘Holiday’ or ‘Half’ in the text, but you could easily customise these formulas to fit your purposes. E.g. you might prefer ‘vacation’ if you are US based.

The holiday tracking spreadsheet could either be used as a locally stored standalone spreadsheet, or if you uploaded it to Office 365 you’d be able to share it with other members of staff. If you aren’t using Microsoft products you can edit this staff holiday planning spreadsheet using the free Libre Office.

Week numbers are included, based on the standard ISO 8601 method of recording the weeks.

Download 2022 staff holiday planner spreadsheet – 13kb

If you have suggestions for improvements to my staff planner please feel free to leave a comment. Hope this spreadsheet makes your 2022 easier to manage.

2021 staff holiday Excel planner – free download

Tuesday, July 13th, 2021

Here is my free Excel staff holiday planner for 2021. There are lots of paid ways of tracking staff holiday, but if you are a small business or organisation then perhaps you want something simple and free.

2021 staff holiday planner excel spreadsheet

This free spreadsheet allows you to customise the people listed and then record holiday, training, and other absences easily. There is a built in formula to track how many holidays each member of staff has left. The easiest way to use the spreadsheet is to copy/paste the categories in from the category box on the top left. If you paste in a ‘Holiday’ then the remaining days goes down by 1, and if you paste in a ‘Half’ then the remaining days goes down by 0.5.

The category box and the employee names on the left are in a frozen pane, so they are always on screen.

Week numbers are included, based on the standard ISO 8601 method of recording the weeks.

Download 2021 staff holiday planner spreadsheet – 13kb

You can load this 2021 calendar into either Microsoft Excel or the free Libre Office. Note that if you are using Microsoft Excel you’ll need to use at least Excel 2007, as older versions like Excel 97 don’t support enough columns to fit in the full 365 days of the year.

The staff holiday planner is easily customisable. You can for example add in public holidays, change the categories, and alter the staff members. Just make sure to double check the ‘remaining days’ formula if you make any changes to the number of columns, you’ll need to make sure it counts the full year to get the correct calculation.

2014 and 2015 Excel staff holiday planner and one page Excel calendar

Monday, December 2nd, 2013

I’ve been getting loads of requests for the 2014 versions of my staff holiday planning spreadsheet, and the one page Excel calendar. I thought it was about time I created them. And for good measure I did the 2015 version as well.

Staff holiday planner

First up here are my latest free spreadsheet that can help you track staff holidays, training, sick days and offsite days.

2014 excel staff holiday planner

They come configured with formulas that can automatically track the total number of holiday days remaining (columns C&D) for each employee. If you don’t want to use this simply delete those columns.

The default formula subtracts 1 or 0.5 from the remaining holiday if the employee cells contain the words ‘holiday’ or ‘half. You can copy and paste (ctrl-c, ctrl-v) the coloured tags (holiday, half, training, etc) from the top left into the staff planning cells and the totals are automatically updated.
It is easy to customise the formulas if you want to factor in sick days for example. See the 2012 planner for more example formulas. Note that the 2014/2015 calendar formulas count the entire row (which includes the last bit of the year before and the first bit of the year after), whereas the 2012 calendar formulas just count the 2012 year. You can adjust the formulas to suit your requirements.

As always the week numbers are based on ISO 8601, and the top and left parts of the staff planner are frozen so you can always see them – this makes navigation easy. Here is the download link:

Download 2014 staff holiday planner spreadsheet – 21kb
Download 2015 staff holiday planner spreadsheet – 21kb

As the staff holiday planner has over 365 columns you won’t see the whole year if you open it with an old spreadsheet package such as Excel 97. You’ll need to use a more modern spreadsheet package such as Excel 2007 or OpenOffice (which is free). One workaround if you are forced to use Excel 97 at work is for you to use OpenOffice at home to split the spreadsheet into 2, one part for H1, and one for H2.

One page Excel calendar

As always you get the whole year in a very simple one page Excel spreadsheet.

2014 one page excel calendar
You should be able to load the XLS using any version of Microsoft Excel from 97 onwards, or using the free OpenOffice or LibreOffice.

2014 one page Excel calendar – 13kb
2015 one page Excel calendar – 13kb

The one page Excel spreadsheet calendars and the staff holiday planners are zipped up. If your OS won’t automatically open the zip files you can download the free 7-Zip to unzip them for you.

The 2016 versions of these spreadsheets are here: https://www.reviewmylife.co.uk/blog/2015/08/30/2016-and-2017-staff-holiday-excel-planner-and-one-page-excel-calendar/.