Technology, life, programming, travel and money.

2013 Staff holiday planner spreadsheet

At the time of writing it nearing the end of 2011 so some of you may be searching for my previous staff holiday planner for 2012. If you are planning very far ahead (or if you are reading this in 2012/2013) you might want my 2013 staff planner. This is my latest free spreadsheet that can help you track staff holidays, training, sick days and offsite days.

2013 staff holiday planner spreadsheet

It comes 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 2013 calendar formulas count the entire row (which includes the last bit of 2012 and the first bit of 2014), 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 2013 staff holiday planner spreadsheet – 23kb

As the staff holiday planner has over 365 columns you won’t see the whole year if you open it with an ancient 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 2013 H1, and one for 2013 H2.


Reader Feedback

22 Responses to “2013 Staff holiday planner spreadsheet”

  1. Darren says:

    we are a small children’s charity and sites like this a amazing… to get free tools like this leaves us more money to help children with Cystic Fibrosis

    THANKS

  2. Tom Simmons says:

    Thanks for this, we just have a question about enhancing it. Is it possible to enter two leave codes into one day?

  3. reviewmylife says:

    Hi Tom, it would be possible, but you’d need a more sophisticated formula to count the cells. The formula would need to search for a substring in the cell instead of doing a direct match.

  4. Leon P says:

    Hi there, this is brilliant but for some reason the spreadsheet no longer updates leave days. I am using Office 2007 and when I use format painter to update cells it does not automatically update leave days left. Is there a reason why this might happen?

  5. reviewmylife says:

    Hi Leon, if it was working before and then it stopped, then you have probably broken the formulas. You could re-download the original spreadsheet and compare the formulas with your version to see if you can fix it.

  6. R S says:

    Your calendar is excellent. Many thanks for your efforts and hats off to you for sharing it with the world too :)

  7. Sara says:

    This is amazing! Thank you so much!

  8. Hello
    thank you so much – we are a charity and been using this for 2 yrs now
    how can I thank you?

    Also I experience a problem – when I save as .xls (using Open Office) I get the following error message: “The Document contains more rows than supported in the selected format – Additional Rows could not be saved” Anyone experience the same?

  9. reviewmylife says:

    Hi Gregory, XLS is a very limited format. I’d suggest saving in the more modern ODS if you are using OpenOffice. For anyone using a more modern Excel you can simply save it in its original file format.

  10. Juls says:

    Hi thanks for the calendars they work very well is there any chance you can upload a 2014 calendar please trying to plan ahead.
    Cheers Juls.

  11. Frank says:

    i love your holiday planner and have used it for the last 2 years. Did you create one for 2014 yet?

  12. TOP GEAR TYRES & SERVICE CENTRE says:

    Absolutely brilliant and perfect in every way.
    Looks great, easy to use and has made planning a breeze.

    Will there be a 2014 and so on.

  13. Danielle says:

    Are you doing one for 2014? This s/sheet is great

  14. David says:

    Hi, love your spreadsheet. Any chance of a 2014 version?
    Thanks
    David

  15. Bill says:

    have found the 2013 cal to be excellent for our office.
    will you have a 2014 version?
    many thnaks
    Bill

  16. Debra says:

    Hi,
    Please, please,please could we have a 2014 version. Have been using this template since 2012 – fantastic!

  17. lorcan says:

    Hi,

    Likewise, have loved the 2013 calendar, would really appreciate a 2014 version

    Cheers,

    Lorcan

  18. Lisa Chandler says:

    Hi

    Your planner was perfect, please can we have a 2014 one. Thanks

    Lisa

  19. Debra says:

    Hi have you been able to sort out a 2014 version yet please?

  20. Con says:

    I loved the 2013 planner. do you have any for 2014 please

  21. TOP GEAR TYRES & SERVICE CENTRE says:

    2014 planner, we would even buy a copy – Brilliant tool