Skip to content

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

Screenshot of the holiday request form template, “Leave request” sheet showing Employee, Employee number, Department, Line manager and Type of leave
“Leave request” sheet: Enter Employee, Employee number, Department and Line manager here.

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
“Leave request” sheet: Enter Employee, Employee number, Department and Line manager here.

How to fill in the template

How to fill in the template

  1. 1

    type of leave, first and last day, bank holidays in the period.

  2. 2

    Working days (Mon–Fri) and the remaining balance are calculated automatically. For other working patterns check the working days manually.

  3. 3

    Sign the request and pass it to your line manager.

  4. 4

    The manager records the decision, date and any reason, and signs.

  5. 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

  • **Ireland

  • **United States

Legal basis and sources

RuleSource
5.6 weeks’ annual leave (28 days for a 5-day week), may include bank holidaysWorking Time Regulations 1998, regs. 13 & 13A
Notice: worker twice the length of leave; employer counter-notice equal to the lengthWTR 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 guidanceGOV.UK
US users: no federal paid-leave entitlement; follow state law and company policyU.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.

What is a holiday request form template?

Leave request vs leave planner: which template do you need?

Leave request form: fields to include

Example formal email for a leave request

For employers

Suggested notice periods

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

See how Ordio digitizes leave management

See digital approvals simplify your workflow · No obligation · 15 minutes

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.