Posts Tagged ‘2022’

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.