-
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
- 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.
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 usingWORKDAYin a sheet:
Formula |
Description |
Result |
|---|---|---|
=WORKDAY([Order Date]1, -5) |
Return the specific workday 5 days before the value in row 1 of theOrder Datecolumn. |
02/05/19 |
=WORKDAY([Order Date]1, -5) + " " |
If theWORKDAYformula is returning the desired result in a Text/Number column instead of a Date column, add+ “ “的公式,以防止一个错误。你会注意到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 theOrder Datecolumn. 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. 你会注意到this formula is the same as the above. The difference being is it’s excluding all of the range of dates found in theHolidaycolumn. |
04/03/19 |
Still need help?
Use theFormula Handbook templateto find more support resources, and view 100+ formulas, including a glossary of every function that you can practice working with in real time, and examples of commonly used and advanced formulas.
Find examples of how other Smartsheet customers use this function or ask about your specific use case in the Smartsheet online Community.