Enter duration as "Net Days" but still count work days without Sat/Sun.
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
Check out the Formula Handbook template!