Free staff holiday calculator

Our free staff holiday calculator lets you work out the holiday allowance for full-time employees, part-time employees, new starters and those leaving your business.

Instructions on how to use our free staff holiday calculator.

Download the calculator using the form on this page.

• Column A: insert employee’s name, just for reference.
• Column B: enter their weekly working hours (for example, in the spreadsheet Tina works 28 hours per week, full-time might be 37.5 hours).
• Column C: enter the start date of your holiday year OR if this employee started after that date, the date when the employee started in the business (Your holiday year may run January to December or April to March).
• Column D: enter the end date for your company holiday year OR if this employee is leaving or left before that date, the date the employee is leaving or left the business.
• Column E: enter the number of days holiday this employee would receive if they were a full-time employee, regardless of their working hours (FTE).
• Column F: this is the total number of hours holiday they are entitled to during this holiday period, these can be rounded to suit.