Skip to content
Employee Vacation Tracker cover: a sample sheet with approved days, waiting for approval and trips planned and a bar chart, beside the Dashboard tab

Employee Vacation Tracker

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
4
Difficulty
Beginner
Updated
November 13, 2026

Every slide (4)

Overview

The Employee Vacation Tracker is for managers and HR staff who approve time off and want to see when the team is away. The Vacation plan tab is a timeline with one row per trip, showing the employee, team, start and end dates, working days and status. The Dashboard totals approved working days, pending requests and the working days booked by team, with a chart for each.

Check the timeline before you approve a request, so that no more than one person in a team is away at once unless you agree it. Working days skip Saturdays and Sundays but not public holidays, so take those off by hand if a trip includes one. Change Requested to Approved or Declined as decisions are made, so the counts stay accurate.

Useful for

  • Plan holiday cover across a busy season
  • Track requests waiting for approval
  • Count working days booked by each team

What's included

  • 3 tabs: Dashboard, Vacation plan, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Vacation plan: a Gantt timeline
  • 2 charts that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Vacation plan tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

How are working days counted?

The working days column uses NETWORKDAYS, which counts Monday to Friday from the start date to the end date, including both. A trip from one Monday to the Friday of the same week shows 5 working days. Public holidays are not removed, so subtract them yourself if your policy does not count them.

How long a period does the timeline show?

The timeline shows 16 weeks. It covers one season, so for a longer view start a new workbook per season and move the trips across.

How do I spot two people in one team away together?

Sort the Vacation plan by team and then by start date, and scan each team's rows for dates that overlap. The timeline shows the same overlap as bars in the same weeks, so you can compare trips at a glance before you decide.

  • #attendance-tracker
  • #vacation-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More attendance tracker templates

See all 8

Also in Human resources

All human resources templates
Get this template

Preparing your template…