WORKDAY Function

Returns the date a number of working days before or after a start date.

Category

Date & Time

Available in

All versions, Microsoft 365

Returns

A date (serial number)

Taught hands-on in Level 3: Intermediate Lookups & Data Summaries · Dates & Times module

Overview

WORKDAY counts forward (or back) a number of working days, skipping Saturdays, Sundays and any holidays you list. Use it for due dates, delivery dates and SLAs.

The start date itself isn't counted.

Syntax

=WORKDAY(start_date, days, [holidays])

Arguments

ArgumentRequired?What it does
start_dateYesThe date to count from.
daysYesWorking days to move: positive for later, negative for earlier.
holidaysOptionalA range of dates to skip as well.

Examples

Example 1 — Delivery dates

Northstar promises delivery in a set number of working days.

C2fx=WORKDAY(A2,B2)
ABC
1OrderedWorking daysDelivers
23/13/202653/20/2026
33/2/2026103/16/2026
43/13/2026-13/12/2026
=WORKDAY(A2,B2) Explain

Example 2 — Skipping holidays

List the holidays in a range and lock it with $ signs.

C2fx=WORKDAY(A2,B2,$E$2:$E$3)
ABCDE
1OrderedWorking daysDeliversHolidays
23/13/202653/24/20263/16/2026
33/17/2026
=WORKDAY(A2,B2,$E$2:$E$3) Explain

Common mistakes

  • The result shows as a number. Format the cell as Short Date.
  • A different weekend. WORKDAY always treats Saturday and Sunday as the weekend. Use WORKDAY.INTL for other patterns.

Notes

Kyle Stott

Author

Kyle Stott

Certified Microsoft Excel Expert

Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.