Posts Tagged ‘2011’

2011 monthly calendar for Excel

Friday, December 17th, 2010

Here is a free monthly calendar for 2011. You can download it as a XLS spreadsheet for Excel, Open Office, or whatever spreadsheet application you use.

I’ve previously produced a one page calendar for 2011, but I had a request to produce a month by month version, with each month on a separate tab. Here is what September 2011 looks like.

2011 monthly calendar

And here is a zoomed in picture of the calendar months listed on the tab at the bottom.

2011 monthly calendar zoomed

It is a free download, and only 13kb zipped up, or 96kb uncompressed.

The days of the week are along the top in a frozen pane, and the weeks are along the side. I’ve put the week numbers in as well (ISO 8601 week numbers if these things matter to you).

Download the 2011 monthly calendar – Excel XLS (13kb zipped)

This calendar should be viewable on Excel 97 and above.

2011 staff holiday planner

Friday, November 12th, 2010

I had a request to create an Excel staff holiday planner in addition to my usual one page calendars that you’ll find on this site. The Excel staff holiday calendar for 2011 can be used to note down holidays, training days, sick days, and home/off-site time at your company. Here’s an example of what it looks like with some information filled in.

2011 staff holiday planner example

Is has the whole of 2011 going left to right, and staff members can be listed from top to bottom. The weekends and months are coloured, and the days are labelled to make it easy to see where you are in the calendar. Week numbers are listed as well – I’m using the ISO 8601 week numbering convention if you are interested in such things.

I’ve frozen the top and left parts of the spreadsheet so they are always on screen. The staff role column has an auto-filter box in case you want to filter by job type. And on the top left (highlighted in the red box below) are a number of colour coded categories that you can easily copy and paste into the relevant cells. Change the category names, and colours to suit your taste.

2011 staff holiday planner categories

To delete the colours in any cells just copy and paste an empty cell over it (Ctrl-C, Ctrl-V is the fastest way).

Here’s a final picture of the blank staff planner which you can download for free from the link underneath it.

2011 staff holiday planner blank

Download the 2011 staff holiday planner calendar – Excel XLS (20kb zipped)

Staff holiday planner with remaining holiday formulas

By popular demand I’ve created a second version of this spreadsheet. This one has built in formulas to calculate the remaining holiday. It has extra slots at columns C and D for allocated holiday, and remaining holiday. Column D counts cells containing the work ‘Holiday’ and ‘Half’ which subtract one day and half a day respectively from column C. If you look in the comments of this page you’ll see some other formulas as well for counting holidays only, and also for counting holidays and sick days as well.

2011 staff holiday planner formulas

I’ve set the XLS to count to the end of 2011 only, even though the holiday planner extends into the first few weeks of 2012. If you want different behaviour you’ll need to make some minor modifications.

Download the 2011 staff holiday planner calendar with formulas – Excel XLS (21kb zipped)

If you have any suggestions for the 2012 version let me know in the comments below.

Note: You’ll need at least Excel 2007 (or OpenOffice which is free!) to view the whole year, as earlier versions of Excel limit the number of columns to 256. And we need 365+ columns to fit the whole year in!

2011 Excel week numbers calendar

Tuesday, September 14th, 2010

If you work in a company then you may find yourself dealing in week numbers rather than dates. E.g. the deadline for this project is week 38!

Here is a free downloadable Excel calendar for 2011 that has the days of the week across the top, and then the week numbers for the whole of 2011 down the side.

2011 week number calendar

Each day has five boxes for you to write in, and the days of the week are frozen at the top, making it easy to see which box is for which day.

I’ve saved two versions. One standard version for modern versions of Excel (2007 and above), and an older version which should work in Excel 97.

2011 Excel week number calendar (for modern versions of Excel – 2007+)
2011 Excel week number calendar (for old versions of Excel – 97+)

If you prefer a month by month view of the year then I also have a one page 2011 Excel calendar on this site available for free download as well as a calendar for 2010.