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.
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:
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.
You should be able to load the XLS using any version of Microsoft Excel from 97 onwards, or using the free OpenOffice or LibreOffice.
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/.