Enter duration as "Net Days" but still count work days without Sat/Sun.

edited 12/09/19 in Formulas and Functions

 Under project settings I want to make Saturday and Sunday as working days so "Hard" products would follow a timeline that includes weekends. A task starting on October 1st with a duration of 31 days would end on Oct 31st.

 I also want to count the number of weekdays (exclude Sat/Sun) between two dates so I calculate total labor cost. A task starting on Oct 1st and ending on Oct 31st would have a duration of 23 days.

 Is there a easy way to accomplish both of these items on the same sheet? Is there a way to use multiple calendars --> similar to Projects?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!