Skip to content
Employee Work Schedule cover: a sample sheet with staff, contracted hours a week and leave days approved and a column chart, beside the Dashboard and Staff tabs

Employee Work Schedule

Spreadsheet template for Google Sheets and Excel

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

Every slide (5)

Overview

Team leads and HR assistants rely on this workbook to record each employee's department, role, start date, working days and contracted hours. The Staff tab holds one row per person. The Leave tab logs each absence with its type, first and last day, status and working days, which the sheet counts with NETWORKDAYS so weekends drop out. The Dashboard shows headcount, contracted hours and approved leave by department and by leave type.

Update the Staff tab whenever someone joins, changes hours or leaves, and keep the Leave tab current as requests move from Requested to Approved or Declined. Only Approved leave reaches the approved days total, so check each status before you plan cover. The working days formula leaves out weekends but counts public holidays, so take those out by hand if your company observes them.

Useful for

  • Keeping a headcount and hours record by department
  • Working out how many leave days are booked to plan cover
  • Checking which leave requests still need a decision

What's included

  • 4 tabs: Dashboard, Staff, Leave, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Staff: a table
  • Leave: a table
  • 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 Staff 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 do I count leave that includes a public holiday?

The working days formula excludes weekends only. To leave out public holidays as well, add a list of holiday dates as the third argument of NETWORKDAYS, or subtract those days by hand. Check your company's leave policy for how holidays count toward leave.

Can I track how much annual leave is left?

This sheet records leave taken, not the allowance. Add an allowance column on the Staff tab, then subtract each person's approved annual days from it. Your leave policy sets the allowance itself.

Does the sheet flag overlapping leave?

Not automatically. Sort the Leave tab by First day and scan for dates that overlap. Look each name up on the Staff tab to see its department before you decide who covers the shifts.

  • #shift-schedule
  • #employee-work-schedule
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More shift schedule templates

See all 9

Also in Human resources

All human resources templates
Get this template

Preparing your template…