Calculating Weekend Days Between Dates

ogonzalez

Hi, 

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?

Sterling

Hello,
try using
=NETDAYS([Date Column 1]1, [Date Column 2]1) - NETWORKDAYS([Date Column 1]1, [Date Column 2]1)
Hope this helps!