Number of day to complete less weekends
I am currently using the formula below to calculate the number of days to complete a task. Is there a way to exclude weekends. (option 1), and possibly a custom list of holidays (option 2)?
=[Resolved Date]@row - [Created Date]@row
Tags:
Answers
-
Use NETWORKDAYS formula to exclude weekend and custom list of holidays.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!