Skip to content
Excel

WORKDAY function in Excel

Returns the serial number of the date before or after a specified number of workdays

=WORKDAY(start_date, days, [holidays])

WORKDAY syntax and parameters

Three arguments, two required.

  • start_dateanyRequired

    A date that represents the start date.

  • daysnumberRequired

    The number of nonweekend and nonholiday days before or after start_date. A positive value for days yields a future date; a negative value yields a past date.

  • holidaysanyOptional

    An optional list of one or more dates to exclude from the working calendar, such as state and federal holidays and floating holidays. The list can be either a range of cells that contain the dates or an array constant of the serial numbers that represent the dates.

WORKDAY examples

Formulas you'll actually reuse.

  1. The date ten working days after a 1 Sep 2026 kick-off:

    =WORKDAY(DATE(2026, 9, 1), 10)

    Result2026-09-15

  2. The same, skipping the public holidays listed in H2:H10 (Labor Day pushes it to the 16th):

    =WORKDAY(B2, 10, H2:H10)

WORKDAY in Google Sheets

Same name — your formula ports as-is.

Try WORKDAY in the playground

Edit the example — nothing to install.

Preloaded with the WORKDAY formula from Example 1 — change anything and watch it respond.

Loading the editor…

Related functions

More ways Excel gets this done.