Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Calculate duration excluding Weekends
Options
Afternoon,
I have a smartsheet where I have a start/received date and a sold/end date. I calculate the difference to determine the duration however I need to exclude Sat & Sun (Friday if possible) in the formula and thoughts?
=NETDAYS([Date Received from xxx]263, [xxx Date Shipped Out]263)
Comments
-
Try using NETWORKDAYS() instead.
-
Thanks perfect
This discussion has been closed.
