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.
14-day money-back guaranteeIf the template doesn't work for you, email info@phkmedia.co.uk within 14 days of purchase and we'll refund you in full — no hoops.
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
14-day money-back guarantee
If the template doesn't work for you, email info@phkmedia.co.uk within 14 days of purchase and we'll refund you in full — no hoops.
Full policy in our Terms.
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 if it doesn't work for me?
You're covered by our 14-day money-back guarantee. If the template doesn't work for you, email info@phkmedia.co.uk within 14 days of purchase and we'll refund you in full — no hoops.
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.