Calculating Weekend Days Between Dates

ogonzalez ✭✭✭
edited 12/09/19 in Formulas and Functions


Looking for a way to calculate the number of weekend days between two dates. Many calculations use the total number of days and divide by 7, but this only gives you total weeks. For example, if a task starts on a Thursday and ends Monday the output should be 2. If you divide this duration by 7 it will give you nothing.

There is a formula for excel that works in excel  =SUM(INT((WEEKDAY(N3-{1,7})+J3-N3)/7)) . Where N3 is the start date and J3 is the end date. The issue with this formula is that the brackets that are referencing Saturday and Sunday create an invalid reference in smartsheet #InvalidREF. Does anyone have a solution to this?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!