Posts Tagged ‘one page calendar’

2016 and 2017 staff holiday Excel planner and one page Excel calendar

Sunday, August 30th, 2015

The requests for the 2016 excel staff holiday planning spreadsheet have been coming in so I have made it as well 2017 one. Also I’ve uploaded the 2016/2017 one page excel calendars.

Staff holiday planner

First up here are my free spreadsheet that can help you track staff leave/holiday, training, sick days, offsite days, etc.

2016 2017 staff holiday planner

They come set up 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.

Note that the formulas measure the tags from the very start column (which is the year before) to the very end column (which is the year after).

See the 2012 planner for some customisation examples.

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 2016 staff holiday planner spreadsheet – 22kb
Download 2017 staff holiday planner spreadsheet – 22kb

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 LibreOffice (which is free). One workaround if you are forced to use Excel 97 at work is for you to use LibreOffice at home to split the spreadsheet into 2, one part for H1, and one for H2.

One page Excel calendar

I’ve put the whole year in this one page Excel spreadsheet.
2016 2017 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.

2016 one page Excel calendar – 13kb
2017 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.

2013 one page Excel calendar

Thursday, April 12th, 2012

I’ve started getting requests for a 2013 version of my one page Excel calendar, so here it is! If you want the previous 2012 one page Excel calendar click on the link.

2013 staff holiday calendar

As always you get the whole year in a very simple one page Excel spreadsheet. There are two versions. One is plain, the other has the UK bank holidays marked.

2013 one page Excel calendar – blank
2013 one page Excel calendar – with UK bank holidays

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 are zipped up. If you OS won’t automatically open the zip files you can download the free 7-Zip to unzip them for you.

2012 One Page Excel Calendar

Wednesday, December 22nd, 2010

At the time I write this 2010 is nearly over, which means that 2012 is just over a year away. If you are planning far in advance then you might appreciate this free downloadable 2012 one page Excel calendar. If 2012 is too far ahead then I have a 2011 one page excel calendar available for download as well.

2012 excel calendar

Just like in previous years this calendar features the whole year on a single page. It should fit on your computer screen, but you might need to adjust the zoom depending on your default settings.

There are two versions, one is plain, and the other has the UK bank holidays marked on it.

2012 one page Excel calendar – blank
2012 one page Excel calendar – with UK bank holidays marked

Both version of the calendar are free to download, and should work on Excel 97 and above, or on OpenOffice (which you can download for free).

2011 One Page Excel Calendar

Thursday, November 19th, 2009

2010 is still over a month away and yet I’ve already had several requests for a 2011 one page excel calendar. The format of my 2010 excel calendar seems to be a good one so I’m repeating it for the 2011 version.

2011 Excel one page calendar

As in previous years I’ve made a blank calendar with just the days / months marked out, and a calendar with the 2011 UK bank holidays highlighted.

2011 Excel calendar – blank (5kb)
2011 Excel calendar – with UK Bank Holidays highlighted (5kb)

Like before you should be able to get it to fit on your computer screen without any scrolling – you may need to adjust the box sizes, or zoom level depending on the resolution of your monitor.

2010 One Page Excel Calendar

Monday, March 9th, 2009

We’re well into 2009 so to follow on from my 2009 Excel one page calendar it seems time to put up the yearly calendar for 2010.

2010 Excel one page calendar

As before I’ve done a blank calendar with just the days / months marked out, and a calendar with the 2010 UK bank holidays highlighted.

2010 Excel calendar – blank (7kb)
2010 Excel calendar – with UK Bank Holidays highlighted (7kb)

Like before you should be able to get it to fit on your computer screen without any scrolling – you may need to adjust the box sizes, or zoom level depending on the resolution of your monitor.

For anyone who is planning well ahead I have now added my 2011 one page excel calendar to this site.

2009 One Page Excel Calendar

Friday, August 29th, 2008

Following on from my 2008 Excel one page calendar I’ve produced a new yearly calendar for 2009.

2009 Excel one page calendar

This time I’ve done a blank one with just the days / months marked out, and one with the UK bank holidays highlighted.

2009 Excel calendar – blank (7kb)
2009 Excel calendar – with UK Bank Holidays highlighted (7kb)

Like before you should be able to get it to fit on your computer screen without any scrolling – you may need to adjust the box sizes, or zoom level depending on the resolution of your monitor.

2008 Excel One Page Calendar

Thursday, January 3rd, 2008

For the past few years I’ve found Excel to be useful for creating one page yearly calendars.

2008 Excel Calendar

Here is is a download link to my 2008 Excel calendar – 2008 calendar. It is free to download for personal or business use. I’ve highlighted UK bank holidays in yellow but you can blank out these cells if you live somewhere else.

It will work with Microsoft Excel 97 and above, as well as the free OpenOffice.

Update: A 2009 Excel calendar is now available.