NETWORKDAYS between a date and a number

Angela.R

How does it work to minus a number of days from a date cell using networkdays?
One column is a Due Date that I would like to populate based on a set date that will be static in [Due Date]9 cell

I put in the Due Date column
=[Due Date]9 - 180 (works fine, and gives me the result of a date based on the cell [Due Date]9 minus 180 but looking for it to be networkdays.

=NETWORKDAYS([Due Date]9, -180) gives an error. I feel is simple and i'm missing it.

Kerry St. Thomas

If you use WORKDAY you should get your answer:
=WORKDAY([Due Date]9, -180).

Check this article out for more info (how to exclude holidays in addition to Saturday/Sunday, and a few examples to help):
https://help.smartsheet.com/function/workday

Kerry St. Thomas

If you use WORKDAY you should get your answer:
=WORKDAY([Due Date]9, -180).

Check this article out for more info (how to exclude holidays in addition to Saturday/Sunday, and a few examples to help):
https://help.smartsheet.com/function/workday