Templates
Holiday Request Form Template – free for Word, PDF and Excel
Release
Version 2026.10
Markets
- UK
- IE
- US
Formats
- Excel (.xlsx)
- Google Sheets
- PDF (fillable)
- Word (.docx)
Editable files: free, after a short form

At a glance
At a glance
Formats
Excel (.xlsx), Google Sheets, PDF (fillable), Word (.docx)
Countries
United Kingdom, Ireland and United States
Automatic checks
7
Public holidays
2026–2028
Legal status
Guidance, not legal advice (checked October 2026)
What's in the template
What's in the template
Fill in
- Employee
- Employee number
- Department
- Line manager
- Type of leave
- First day of leave
- Last day of leave
- Half days in period (0–2)
- Annual leave entitlement (days)
- Carried over from last year
- Already taken/approved
- Cover arranged with
- Handover notes
- Date of request
- Company notice rule (calendar days)
- Decision
- Date of decision
- Reason if refused/changed
Automatic
- Working days requested (Mon–Fri)
- Calendar days
- Counted against annual leave
- Remaining after this request
Dropdowns
- Decision: Approved, Refused, Approved with changes
- Type of leave: Annual leave, Time off in lieu, Unpaid leave, Compassionate leave, Training leave
Public holiday list for 2026–2028 covering United Kingdom, Ireland and United States. The template marks holidays in the calendar automatically.
Automatic
Result
How to fill in the template
How to fill in the template
- 1
type of leave, first and last day, bank holidays in the period.
- 2
Working days (Mon–Fri) and the remaining balance are calculated automatically. For other working patterns check the working days manually.
- 3
Sign the request and pass it to your line manager.
- 4
The manager records the decision, date and any reason, and signs.
- 5
The “Checks” sheet flags missing details, the balance and the statutory notice rule.
How the template calculates
How the template calculates
Formulas
Leave is counted in working days – weekends and (where listed) bank holidays don’t count. Remaining = entitlement + carry-over − days taken. Checks flag overlaps, missing details or deadlines.
Remaining = entitlement + carry-over − days taken
Quick tips
Fill in the yellow cells; grey cells calculate – don’t overwrite them. ✔ = OK, ⚠ = check. Enter times as hh:mm and dates as dates; add new dropdown values on the source sheet first. If you see #VALUE! or empty totals, press Ctrl+Z or reload the template.
Rules by country
Rules by country
verified·estimate·pending
**United Kingdom
** Default: 5.6 weeks = 28 days for a 5-day week, which may include the 8 bank holidays (Working Time Regulations 1998, regs 13/13A).
**Ireland
** 4 working weeks = 20 days for a 5-day week (or 8% of hours worked); leave year April – March; 10 public holidays (OWTA 1997 s. 19, 21).
**United States
** no federal paid-leave entitlement – follow your policy and state law (e.g. paid sick leave rules); federal holidays are not mandatory for private employers.
Bank holidays – used to count working days on “Leave request”
Legal basis and sources
| Rule | Source |
|---|---|
| 5.6 weeks’ annual leave (28 days for a 5-day week), may include bank holidays | Working Time Regulations 1998, regs. 13 & 13A |
| Notice: worker twice the length of leave; employer counter-notice equal to the length | WTR 1998, reg. 15 |
| Irregular-hours and part-year workers: accrual at 12.07% of hours worked (leave years from 1 Apr 2024) | WTR 1998, reg. 15B |
| Holiday entitlement guidance | GOV.UK |
| US users: no federal paid-leave entitlement; follow state law and company policy | U.S. Department of Labor |
Guidance only, not legal advice – contracts and collective agreements can differ. The file holds personal data (UK GDPR / GDPR): share it only with people who need it and delete it once the retention period ends.
Checks and dashboard
Checks and dashboard
Last day is not before first day
At least 1 working day requested
Balance after request not negative
Notice given (at least twice the length of leave, WTR reg. 15)
Decision recorded
Reason recorded if refused
Bank holidays
Formats
Excel, Google Sheets, PDF or Word
PDF (fillable)
Print it or fill it in on screen, without formulas.
Word (.docx)
Edit the wording freely in Word or LibreOffice.
- Recommended
Excel (.xlsx)
Calculate, check and archive on your computer – Excel 2016 or later, Microsoft 365.
Google Sheets
Use it in the browser and share it with your team – via File › Make a copy.
Print, share, save
Print: File › Print → A4 (UK, Ireland) or US Letter (US), choose orientation, scale “Fit to width”, repeat frozen rows.
PDF/Excel: File › Download › PDF or Microsoft Excel (.xlsx).
Your own copy: File › Make a copy. Share: “Share” top right – ideally “Viewer” for the team.
Limits of the template
Public holidays cover 2026–2028. Add later years to the list yourself.
Formula cells are only protected with a warning, and a spreadsheet keeps no change log: anyone who can open the file can edit it.
If several people need to plan or record at the same time, software such as Ordio is easier.
Related templates and tools
- Absence management in Ordio
- Internship Report Template – free for Word, PDF and ExcelFree internship report template for Excel and Google Sheets. Internship report structure with weekly tasks and reflection sections. Download now.
- Annual Leave Planner Template for Excel and Google SheetsFree vacation planner template excel for Excel and Google Sheets. Team vacation planner with requests, balances, and calendar overview. Download now.
- Duty Roster Template for Excel and Google SheetsFree duty roster Excel template for Excel or Google Sheets. FLSA and UK hour checks, industry presets, hour totals, CSV export for staff rotas.
- Parental Leave Request Template – free for Word, PDF and ExcelExcel request asking an employer for parental leave dates. Not a German Elternzeit notice, an FMLA certification, or a UK shared-parental-leave form.
- Shift Plan Template for Excel and Google SheetsFree shift plan and shift schedule Excel template for rotating teams. Excel or Google Sheets, FLSA and UK checks, 3-shift and 24/7 cover, hour totals…
What is a holiday request form template?
A holiday request form template (also called a leave request template, leave request form, or annual leave request form) is a standard layout for asking your employer for time off. It records name, department, dates, leave type, remaining balance, and cover so your manager can approve and payroll can apply the right rules.
You can download this leave form free, fill it in offline, and email or print it, no subscription to a form builder. The same fields work in Excel and in Google Sheets after you make a copy of the Sheets version.
Common types of leave you might list on one form:
- PTO / vacation (US): Paid time off under your handbook, often one pool or split vacation and sick. See our paid time off (PTO) glossary.
- Annual leave (UK): Statutory and contractual days, usually booked in working days, not calendar days. See holiday pay for pay calculation basics.
- Sick leave: Short-term illness; documentation rules vary by US state and UK fit-note rules.
- Parental or protected leave: Not the same as vacation, US FMLA and UK parental leave use separate processes.
- Unpaid leave: When paid entitlement is used up or for personal leave without pay.
The workbook calculates working days between start and end dates and includes a Compliance sheet that flags balance or date issues before you submit. Send the file by email, upload it to your HR portal, or print a signed copy.
Further reading: Holiday and PTO accrual calculator.
Leave request vs leave planner: which template do you need?
Use the right free template so you do not mix up an individual request with a team calendar. Employees start here: download the form, fill dates and cover, and get approval. Supervisors and HR then record approved leave in a leave planner so rotas, balances, and clash checks stay in one view, especially when several people share the same shift pattern.
If you only need your own dates on paper, use this page. If you are planning who can be off in August or over Christmas, open the leave planner template instead (or use both after each request is approved).
| Aspect | Leave request (this page) | Leave planner |
|---|---|---|
| Purpose | One employee asks for time off | Manager or HR sees the whole team |
| Contents | Dates, leave type, balance, cover | Roster, balances, approved dates, calendar view |
| Typical user | Employee | Supervisor, office manager, HR |
| Ordio template | Holiday request template | Leave planner template |
Leave request form: fields to include
A useful time off request template includes the fields HR and payroll expect on the first submission, especially when you download a free form and send it by email instead of using an HR app.
| Field | Why it matters |
|---|---|
| Employee name & department | Identifies who is away and who approves |
| Leave start and end dates | Defines the absence window for payroll and cover |
| Working days requested | Avoids charging calendar days when policy counts Mon–Fri only |
| Leave type (PTO, annual leave, sick, unpaid) | Routes to the right policy and pay rules |
| Remaining balance | Shows you are not overdrawn before travel is booked |
| Cover / handover contact | Keeps shifts and customers covered in hospitality and retail |
| Signature and date | Creates a written record if email alone is not enough |
| Manager approval (optional row) | Shows who approved the leave and when |
Example formal email for a leave request
A formal email for a leave request should be polite, specific, and complete: subject line, dates, type of leave, cover arrangement, and a clear ask for approval. Email can supplement a signed form where your policy requires both.
Adapt these three examples, replace the bracketed placeholders with your details.
Subject
Example 1: Standard PTO or annual leave
Subject: Leave request – [start date] to [end date]
Body: Dear [Manager name], I would like to request paid leave from [start date] to [end date] ([number] working days). I have sufficient balance remaining. [Colleague name] has agreed to cover urgent tasks. Please let me know if you approve. Kind regards, [Your name]
Subject
Example 2: Short-notice request
Subject: Urgent leave request – [date]
Body: Hi [Manager name], I need to take leave on [date] due to [brief reason if appropriate]. I still have PTO or annual leave available, and [colleague] can cover my shift. Thank you for considering this at short notice. Best regards, [Your name]
Subject
Example 3: Longer block of leave
Subject: Leave request – [start] to [end] ([number] working days)
Body: Dear [Manager name], I am requesting leave from [start date] to [end date] ([number] working days in total). Handover is arranged with [colleague]. I will check email occasionally if needed. Could you confirm approval when convenient? Kind regards, [Your name]
Keep written confirmation of approval. Attach the completed workbook if HR needs a file copy.
For employees
- Proof: Approved requests support pay, holiday pay calculations, and return-to-work conversations.
- Planning: Early submission improves approval odds for popular weeks and school-holiday periods.
- Balance clarity: Stating remaining PTO or annual leave avoids overdrawing entitlement before flights or deposits are paid.
- Cover: Naming a colleague or handover contact shows managers the rota can still run.
For employers
- Staffing: Managers can adjust rotas before the leave starts, see employee scheduling.
- Payroll: Working-day totals and leave type help payroll apply the right pay rules (paid PTO vs unpaid vs protected leave of absence).
- Compliance: Documented decisions support fair treatment, grievance handling, and audits.
- Scale: Compare absence management software when email threads and shared drives no longer scale.
Employee checklist before you send
- Dates and working-day total match the workbook (and your email).
- Leave type matches policy (PTO, annual leave, sick, unpaid, not FMLA unless you use the separate process).
- Remaining balance is current from payslip or HR portal.
- Cover colleague or handover is named and has agreed informally.
- Form is signed (or PDF attached) if HR requires a file copy.
When to submit
Submit at least two to four weeks ahead for standard vacation unless policy says otherwise. Peak periods (summer, Christmas, US holiday weekends, UK school holidays) may need three months’ notice in the handbook. If your contract says nothing, the Working Time Regulations set a default in Great Britain: give notice of at least twice the length of the leave (10 days’ notice for 5 days off). Your employer can refuse with notice equal to the length of the leave (reg. 15).
Suggested notice periods
| Leave type | Typical notice | Notes |
|---|---|---|
| Peak vacation (US/UK) | 1–3 months | Handbook or rota planning; first-come policies are common |
| Standard PTO / annual leave | 2–4 weeks | Allows cover planning; in Great Britain the default notice is twice the length of the leave (WTR reg. 15) |
| Sick leave | Same day or ASAP | US state sick laws and UK fit-note rules may apply after several days |
| Short notice (discretionary PTO) | As soon as possible | Discuss with manager first; approval not guaranteed |
| Unpaid or personal leave | Per handbook | Often needs longer notice and explicit approval |
| FMLA / parental (US) | Per federal eligibility rules | Separate from PTO paperwork; see leave of absence |
Filing
Keep approved requests with your holiday records and note the approval date. In Great Britain, employers must keep records showing compliance with holiday entitlement and holiday pay for six years (Working Time Regulations 1998, reg. 16B, in force since 6 April 2026). In Ireland, working-time records, including annual leave and public holidays, must be kept for three years (Organisation of Working Time Act 1997, s. 25). In the US, follow your state’s payroll record rules.
Manage leave digitally with Ordio
Automatic balances and approvals save time
Automatic leave calculation
Track entitlements without manual spreadsheets
Digital approvals
Submit and approve leave requests online, no paperwork
Overview for everyone
Staff see balances; managers approve in one click
Linked to scheduling
Approved leave updates shift plans automatically
With Ordio:
See how Ordio digitizes leave management
See digital approvals simplify your workflow · No obligation · 15 minutes
More free templates
Discover more Excel templates for planning, time tracking and HR.
Frequently asked questions about Vacation request template
How much notice do I need to give for annual leave in the UK?
If your contract says nothing, give notice of at least twice the length of the leave, for example 10 days’ notice for a week off. Your employer can refuse with notice equal to the length of the leave (Working Time Regulations 1998, reg. 15). (Source: legislation.gov.uk)
Can my employer refuse a holiday request?
Yes. In the UK they can refuse with notice at least as long as the leave requested, but they must still let you take your 5.6 weeks’ statutory leave in the leave year. In Ireland the employer decides when leave is taken after consulting you and must consider your family responsibilities (Organisation of Working Time Act 1997, s. 20). (Source: irishstatutebook.ie)
What is a holiday request form template?
A vacation request template is a pre-built leave request form usually in Excel or Google Sheets, that records dates, leave type, working days, balance, and cover before your manager approves time off. The Ordio file calculates working days automatically and includes sample emails for US PTO and UK annual leave.
Is the holiday request form template free, and does it work in Excel and Google Sheets?
Yes. You download it free of charge after a short form and get an Excel file (.xlsx, Excel 2016 or Microsoft 365) and a Google Sheets copy, plus a fillable PDF and a Word document. Excel and Sheets contain the same 6 sheets: Instructions, Leave request, Bank holidays, Checks, Legal basis, Ordio.
Which countries does the template cover?
The template covers the United Kingdom, Ireland and the United States. The country notes in the file set out the rules for each: United Kingdom: Default: 5.6 weeks = 28 days for a 5-day week, which may include the 8 bank holidays (Working Time Regulations 1998, regs 13/13A). Ireland: 4 working weeks = 20 days for a 5-day week (or 8% of hours worked); leave year April–March; 10 public holidays (OWTA 1997 s. 19, 21). United States: no federal paid-leave entitlement – follow your policy and state law (e.g. paid sick leave rules); federal holidays are not mandatory for private employers.
Holiday request or vacation request form — which term fits?
UK and Ireland teams usually say holiday or annual leave; US teams often say vacation or PTO. The sheet captures dates, days requested and manager approval in both naming styles, with a US Letter export on the same page. Download Word or PDF when you need a signature.