01
Works out statutory leave for this leave year for up to 12 people: 5.6 weeks × days a week
Capped at 28 days
For small employers in England, Scotland & Wales
6 reasons to work out holiday entitlement the GOV.UK way
A new starter in September, a leaver in July, someone on six days a week: how much holiday does each one actually get? This calculator works it out for up to 12 people, the GOV.UK way, and shows every step so you can explain it.
- Excel & Google Sheets, no macros
- Example + blank file
- Start-here guide
- One-off price, no subscription
Screens from the included example file. All names and figures are fictional.
12people
5.6weeks × days a week, capped at 28 days
12.07%for irregular hours
0macros, add-ons or subscriptions
The list
Why a ready-made calculator beats paper and a blank spreadsheet
02
Starters pro-rated by months started and rounded up to the next half day
(regulation 15A, as GOV.UK does it)
Get the calculator · £2.99 Instant download · Excel & Google Sheets
03
Leavers, and people who start and leave in the same year
Pro-rated by calendar days employed (regulation 14)
Irregular-hours and part-year workers
12.07% of hours worked, rounded to the nearest hour
Adds any extra contract days on top, and shows days and hours
A check column flags missing entries and wrong dates. The Step by Step tab…
…explains any person's number. Dashboard with totals and charts
Get the calculator · £2.99 Instant download · stuck? Email us for help
Compare
Three ways to keep these records
| Feature | Paper or notes | A blank spreadsheet | This calculator |
|---|---|---|---|
| Leavers, and people who start and leave in the same year | ✗No | ~ If you build it | ✓ Built in |
| Irregular-hours and part-year workers | ✗No | ~ If you build it | ✓ Built in |
| Adds any extra contract days on top, and shows days and hours | ✗No | ~ If you build it | ✓ Built in |
| Cost | Free, plus your time | Free, plus your time | £2.99 once |
What's inside
Everything you download
3 files
- XLSX UK-Holiday-Entitlement-Calculator-Lite.xlsxfilled with fictional example staff so you can see how it works
- XLSX UK-Holiday-Entitlement-Calculator-Lite-BLANK.xlsxempty and ready for your team
- PDF Start-here.pdfone-page quick-start guide, including how to open it in Google Sheets
Good to know
- The irregular-hours method applies to leave years starting on or after 1 April 2024. The file warns you if your leave year starts earlier
- Bank holidays can be counted as part of the 5.6 weeks. There is no extra legal right to bank holidays on top
- One licence for your own business
Is it right for you?
Made for some, honestly not for others
A good fit if you…
- small employers, office managers and bookkeepers in England, Scotland and Wales who need the statutory holiday entitlement for this leave year
- use Excel or Google Sheets on a computer
- want to pay once, not another subscription
Not for you if you…
- need Apple Numbers or mobile-only editing
- want someone to do the records for you
How it works
Three steps to get going
- 1
Settings
Your business name and the first day of your leave year (about 1 minute)
- 2
Staff
Name, working pattern, days a week, and a start or leaving date if it falls in this leave year
- 3
Step by Step
Pick a name to see how the number was worked out. The Dashboard shows totals and anything to check
Microsoft Excel2010 or newer (Windows & Mac) and Microsoft 365
Google SheetsFree Google account. Upload the .xlsx, then set the locale to United Kingdom
0
No macrosNothing to enable, no add-ons or subscriptions. Not designed for Apple Numbers or mobile-only editing. A computer is recommended
- Instant download
- Example + blank file
- Start-here guide
The offer
UK Holiday Entitlement Calculator Lite
£2.99one-off · no subscription
- Filled with fictional example staff (UK-Holiday-Entitlement-Calculator-Lite.xlsx)
- Empty and ready for your team (UK-Holiday-Entitlement-Calculator-Lite-BLANK.xlsx)
- One-page quick-start guide, including how to open it in Google Sheets (Start-here.pdf)
- Licensed for use within one business or household
Price includes VAT where applicable — calculated at checkout. Secure checkout by Payhip.
Questions? Email info@phkmedia.co.uk
Stuck after you buy? We'll help you set it up.
Digital download, nothing is posted. This calculator works out the statutory minimum holiday entitlement. Terms & licence.
Need more?
Ready for the full version?
PTO & Leave TrackerKnow every employee's holiday balance today, who is off next, and what needs your attention, without HR software or a monthly fee.
£16.99
Holiday Pay CalculatorZero-hours, casual and term-time staff build up holiday at 12.07% of the hours they work, and their holiday pay must be worked out from their average…
£13.99
FAQ
Questions people ask
Does it book leave or track what is left?
No, this Lite works out entitlement only. Our PTO & Leave Tracker does bookings and balances.
Does it work out holiday pay?
No. See our UK Holiday Pay Irregular Hours calculator for that.
What happens after I pay?
This is a digital product. Nothing physical will be shipped. Your download link appears straight after checkout and is also emailed to you.
Can I get help if I'm stuck?
Yes. Message us at info@phkmedia.co.uk and we'll help you set it up.