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})+J3N3)/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?
Tags:
Comments

Hello,
try using
=NETDAYS([Date Column 1]1, [Date Column 2]1)  NETWORKDAYS([Date Column 1]1, [Date Column 2]1)
Hope this helps!
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!