Skip to content
Google Sheets

WORKDAY function in Google Sheets

Calculates the end date after a specified number of working days.

=WORKDAY(start_date, num_days, [holidays])

WORKDAY syntax and parameters

Three arguments, two required.

  • start_dateanyRequired

    The date from which to begin counting.

  • num_daysnumberRequired

    The number of working days to advance from start_date. If negative, counts backwards. If num_days is not an integer, the decimal part is truncated. That is, WORKDAY(A2,1.9) is equivalent to WORKDAY(A2,1).

  • holidaysanyOptional

    [ OPTIONAL ] - A range or array constant containing the dates to consider holidays. The values provided within an array for holidays must be date serial number values, as returned by N or date values, as returned by DATE, DATEVALUE or TO_DATE. Values specified by a range should be standard date values or date serial numbers.

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 Excel

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 Google Sheets gets this done.