Practice free

WORKDAY function

WORKDAY returns the date a given number of working days from a start date, skipping Saturdays, Sundays and any holidays you list. It is good for delivery dates and deadlines.

Example

Read it as a sentence: find the workday 1 day after January 16, 2026, skipping weekends and the holidays listed in H1:H3, which gives 46042.

Practice this in the app

Syntax

WORKDAY(start_date, days, [holidays])

Arguments in [square brackets] are optional.

start_date (required)
Starting date.
days (required)
Working days to move; positive is forward, negative is back.
holidays (optional)
Optional list of dates to skip.

Returns: The date a given number of working days from the start.

What Excel actually returns

Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.

FormulaExcel showsCase
=WORKDAY(DATE(2026,1,9),1) 46034 Friday + 1
=WORKDAY(DATE(2026,1,9),-1) 46030 Backwards
=WORKDAY(DATE(2026,1,10),0) 46032 Saturday + 0
=WORKDAY(DATE(2026,1,9),1.9) 46034 Fractional days
=WORKDAY(DATE(2026,1,9),{1,2,3}) 46034 Array days
=WORKDAY(DATE(2026,1,16),1,Data!H1:H3) 46042 Skips MLK holiday
=WORKDAY("x",1) #VALUE! Bad date
=WORKDAY(DATE(2026,1,9),"x") #VALUE! Bad days

The Data sheet these formulas read

A cell that starts with = holds that formula.

Watch out for

  • The start date itself is not counted.
  • Returns a serial number; format as a date.
  • Holidays must be real dates.

Where it works

Excel
WORKDAY is in every version of Excel from 2007 on.
Google Sheets
Same name, same behaviour for everyday use.

Part of Date and time functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .