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

Howard Brenner
Howard Brenner ✭
edited 12/09/19 in Archived 2017 Posts

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)

Tags:
· Share on FacebookShare on Twitter

Comments

This discussion has been closed.

Categories