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.
- 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.
For new starters
You can calculate the holiday entitlement for a new starter at any point during the year by simply adding in their start date to column C and the end of the holiday year in column D.
For example: Sue joined on 1st February 2021 so her start date is 2021-02-01 and her end date is the end of the calendar year. The calculator will work out her hours for this time period.
Get in touch if you have any questions, we would be delighted to help or explain more about calculating holiday.
You may also like:
Download our free holiday calculator:
By sending this information you agree to receive updates from us. You can unsubscribe at any time.
Receive HR updates
Sign up for our monthly newsletter.
Free HR advice
Book a 15 min call with our HR consultants.
Guidance on how to get HR support for your business.