Posts Tagged ‘planner’

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.

Monthly Excel planner

Monday, December 19th, 2011

I’ve previously produced a weekly planner Excel spreadsheet, but recently I’ve needed to use a monthly planner with hourly time slots.

It is a simple one page monthly planner. The times from 6am-1am are along the top, and the days of the month from 1-31 are down the side. For the months with 28, 29, or 30 days long you can just cross out or delete the extra days. If you need a different time range it is very easy to edit as well.

monthly excel planner

You can either use this on screen, or print it out. With Microsoft Excel there is an easy option to specify that you want the planner to fit on a single A4 sheet of paper. In the ‘Page Setup’ window set the orientation to Landscape and tell it to fit to 1 page wide by 1 page tall. Here is the free download link:

Download monthly Excel planner – 9kB zipped

I’ve saved this as a Microsoft Excel 97 XLS file so it should work in all old or new version of Microsoft Excel or OpenOffice.

2012 Excel week numbers calendar

Wednesday, June 15th, 2011

We are nearly half way through 2011 so you might have already started planning for 2012. This easy to read one page Excel calendar has the whole of 2012 on one page, with a good sized box for each day of the week – each day has five free cells for your use.

It has the week numbers down the side – the week numbers are written according to ISO 8601. If you work in a company and your projects are planned in terms of week numbers it can be very useful to have a calendar which lists them.

2012 excel week numbers calendar

I’ve frozen the days of the week lables at the top so they are always visible, and the months are alternately coloured to make it easy to see which month you are on.

There are two versions of this spreadsheet, one saved using the newer XLSX format, and one using the older Excel 97 compatible XLS format. Both file types can also be loaded in the free OpenOffice Calc spreadsheet if you don’t have Microsoft Excel.

2012 week numbers calendar (Excel 2007+ or OpenOffice)
2012 week numbers calendar (Excel 97+ or OpenOffice)

I also have a one page calendar for 2012, and a staff holiday planner for 2012 if you are looking for a slightly different calendar.