Posts Tagged ‘holiday planner’

2022 staff holiday calendar – free excel spreadsheet

Sunday, October 31st, 2021

It is getting close to 2022 so your staff might be starting to request holiday and time off for 2022. Following on from my 2021 staff holiday planner, is my free spreadsheet for 2022.

2022 staff holiday planner excel spreadsheet

It can be very useful to visualise everyone’s holiday/vacation on a single spreadsheet as then you can make sure that time offs between staff are appropriately distributed. Equally important is to ensure that everyone takes their full holiday allowance!

This spreadsheet can also be used for tracking training, unpaid leave, working from home and sick days. You could add additional formulas to track these other types of leave if they are important to you.

As usual the spreadsheet has the days of the year running from left to right, with a separate row for each member of staff. There are some in built formulas for calculating remaining holiday. You’ll see the formula works by counting cells with either ‘Holiday’ or ‘Half’ in the text, but you could easily customise these formulas to fit your purposes. E.g. you might prefer ‘vacation’ if you are US based.

The holiday tracking spreadsheet could either be used as a locally stored standalone spreadsheet, or if you uploaded it to Office 365 you’d be able to share it with other members of staff. If you aren’t using Microsoft products you can edit this staff holiday planning spreadsheet using the free Libre Office.

Week numbers are included, based on the standard ISO 8601 method of recording the weeks.

Download 2022 staff holiday planner spreadsheet – 13kb

If you have suggestions for improvements to my staff planner please feel free to leave a comment. Hope this spreadsheet makes your 2022 easier to manage.

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.