WORKDAY Function

Used in a Date column to return a date from a specified number of working days.
Sample Usage
WORKDAY([Due Date]1, 30, [Due Date]2:[Due Date]3)
Syntax
WORKDAY(
  • date
  • num_days
  • [
    holidays
    ]
)
  • date
    The date to begin counting from.
  • num_days
    The number of working days before (negative number) or after (positive number) the date.
  • holidays
    —[optional]
    The dates to exclude from the count.
Usage Notes
  • WORKDAY, NETWORKDAY, and NETWORKDAYS count Saturday and Sunday as non-working days. If dependencies are enabled on your sheet you can customize the non-working days, and the formulas will use your settings in calculations.
  • You can designate other dates as nonworking to exclude them when calculating the new date. To do this, enter each holiday/non-working day into a cell and then reference the range of cells in your WORKDAY formula.
Examples

This example references the following sheet information:

Row #

Clothing Item

Assigned To

Order Date

Holidays

1

T-Shirt

corey@smartsheet.com

02/12/19

12/25/19

2

Pants

mark@smartsheet.com

02/15/19

11/28/19

3

Jacket

sara@smartsheet.com

02/20/19

02/14/20

4

Jacket

tim@smartsheet.com

02/20/19

07/04/19

 

Given the table above, here are some examples of using WORKDAY in a sheet:

 

Formula

Description

Result

=WORKDAY([Order Date]1, -5)

Return the specific workday 5 days before the value in the “Order Date” column row 1.

02/05/19

=WORKDAY([Order Date]1, -5) + " "

If the WORKDAY formula is returning the desired result in a TEXT column instead of a DATE column you’ll want to add a + “ “ to the formula to prevent an error. You’ll notice this formula is the same as the above with the added value so it can be added to a text column. 

02/05/19

=WORKDAY([Order Date]3, 15, DATE(2019, 3, 1))

Return the specific workday 15 days after the value in the “Order Date” column row 3. Exclude the date 03/01/19.

03/14/19

=WORKDAY([Order Date]4, 30, Holidays:Holidays)

When excluding holiday dates you can also reference a range of excluded dates or other single-cell values. 

 

You’ll notice this formula is the same as the above. The difference being it’s excluding all of the range of dates found in the “Holiday” column.

04/03/19