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 nonworking days. If dependencies are enabled on your sheet you can customize the nonworking 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/nonworking 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 row 1 of the Order Date column.

02/05/19

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

If the WORKDAY formula is returning the desired result in a Text/Number column instead of a Date column, add + “ “ to the formula to prevent an error. You’ll notice this formula is the same as the above with the added value, so you can add it 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 row 3 of the Order Date column. 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 is it’s excluding all of the range of dates found in the Holiday column.

04/03/19
 

Still need help? 

Use the Smartsheet Formula Template to view examples and practice working with functions in real-time.

Find examples of how other Smartsheet customers use this function or ask about your specific use case in the Smartsheet online Community.

Ask the Community