Skip to content

Templates

Out-of-Office Message Template for Excel and Google Sheets

Release

Version 2026.10

Markets

  • UK
  • IE
  • US

Formats

  • Excel (.xlsx)
  • Google Sheets

Editable files: free, after a short form

Screenshot of the out-of-office message template, “Absence note” sheet showing Name, Job title / department, Email, Reason (stated only in general terms) and First day away
“Absence note” sheet: Enter Name, Job title / department, Email and Reason (stated only in general terms) here.

Overview

At a glance

  • Sheets

    5

  • Checks

    5

  • Holiday years

    2026

  • Countries

    United Kingdom · Ireland · United States

  • Formula cells

    17

Sheets

What's in the template

Fill in

  • Name
  • Job title / department
  • Email
  • Reason (stated only in general terms)
  • First day away
  • Last day away
  • Cover (name)
  • Cover (email)
  • Cover (phone)
  • Emails forwarded?

Automatic

  • Back on (next working day)
  • Working days (Mon–Fri)
  • Subject
  • External message
  • Internal message (short)
  • Characters (external)

Dropdowns

  • Emails forwarded?: Yes, No
  • Reason (stated only in general terms): Annual leave, Business trip, Training, Parental leave, Out of office
“Absence note” sheet: Enter Name, Job title / department, Email and Reason (stated only in general terms) here.

How to fill in the template

How to fill in the template

  1. 1

    Fill in the yellow fields on the “Absence note” sheet: name, reason, dates, cover.

  2. 2

    The return date (next working day Mon–Fri) and messages are generated automatically.

  3. 3

    Paste subject and text into Outlook (File › Automatic Replies), Gmail (Settings › Vacation responder) or Teams.

  4. 4

    The “Checks” sheet flags missing or sensitive details.

  5. 5

    Switch the note on on your last working day and off when you are back.

Calculations

How the template calculates

  • Working days (Mon–Fri)

    counts working days, excluding weekends and listed holidays; moves a date by working days (deadline/return date)

    =IF(OR($B$10="",$B$11="",$B$11<$B$10),"",WORKDAY($B$11,1))

  • Back on (next working day)

    2026-07-20

  • External message

    Thank you for your message. I am on annu

  • Cover email looks valid

    counts or raises ⚠ warnings

  • Last day is not before first day

    counts or raises ⚠ warnings

  • No health details in the text

    counts or raises ⚠ warnings

  • Note

    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.

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

Countries

Rules by country

Bank holidays and regions are on the holidays sheet when the workbook supports multiple countries.

verified·estimate·pending

  • United Kingdom

Legal basis and sources

RuleSource
Data minimisation – share only what is neededUK GDPR / GDPR Art. 5(1)(c)
Health data is special-category dataUK GDPR / GDPR Art. 9
Monitoring and forwarding employee email: be transparent, follow your policyICO – Employment practices: monitoring workers

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

Checks and dashboard

  • Last day is not before first day

    Automatic check: Last day is not before first day

  • Return date is a working day

    Automatic check: Return date is a working day

  • Cover named with email

    Automatic check: Cover named with email

  • Cover email looks valid

    Automatic check: Cover email looks valid

  • No health details in the text

    Automatic check: No health details in the text

Formats

Excel or Google Sheets

  • Excel (.xlsx)

    Calculate, check and archive on your computer – Excel 2016 or later, Microsoft 365.

    • Calculates automatically
    • Print
    • Edit in Word
    • Offline
  • Google Sheets

    Use it in the browser and share it with your team – via File › Make a copy.

    • Calculates automatically
    • Print
    • Edit in Word
    • Offline

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 an out-of-office message and why do you need a template?

Set up out-of-office in Outlook: step-by-step

Structure of a professional out-of-office message

Internal vs. external: differences in wording

Tips and common mistakes

Three situations that need different wording

Manage absences 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 Out-of-Office Note

What is an out-of-office message and why do you need a template?

An out-of-office message (absence auto-reply) tells senders you are unavailable, on holiday, sick leave, or travelling. It sets expectations, cuts follow-up mail, and looks professional. An out-of-office template saves time: reuse proven text for Outlook, Gmail, or Microsoft 365 instead of rewriting each absence.

What belongs to a professional absence notice?

Cover letter, thanks for the message, absence period, representation (name and contact) and final formula. Short and objective - 40 to 80 words. No personal details, no emoticons. For e-mail addresses in the representation: (at) instead of @, which reduces spam. The Ordio template contains all fields structured - you fill them out and copy the text.

How do I set an absence in Outlook?

Outlook Desktop: File → Automatic answers, enable, set start and end date, enter text. Outlook Online: Gear → E-Mail → Automatic Answers, Activate Switch, Select Period. You can use different texts for internal and external recipients. The Ordio template delivers the finished text - you copy it and insert it.

Is the out-of-office message 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. Excel and Sheets contain the same 5 sheets: Instructions, Absence note, 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: The “Legal basis” sheet refers to UK law (UK GDPR, ICO guidance). Ireland: the EU GDPR applies (regulator: Data Protection Commission); health data is special-category data (Art. 9 GDPR) – never mention illness in an out-of-office note. United States: the GDPR does not apply, but keep health details out anyway – under the ADA, medical information employers obtain must be kept confidential and in separate files (29 CFR 1630.14). Check the return date against your company holiday calendar. Note: Guidance only, not legal advice. Status: October 2026.