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



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)


This discussion has been closed.