Counting days of the week excluding Sunday & Holidays

I am trying to count the number of days over a period of time that include Saturdays, but exclude Sundays and holidays. Is there a known formula for that?

This is a formula I found for excel but isn't working in SS:

=SUM(INT((WEEKDAY([LOAD IN START]@row - {2,3,4,5,6,7}) + [LOAD IN END]@row - [LOAD IN START]@row) / 7))

Best Answer

  • Hollie Green
    Hollie Green ✭✭✭✭✭✭
    Answer ✓

    It automatically excludes your non-working days that are set on the sheets project settings. The default is mon-fri as working days but it can be changed in the project settings to mon-sat


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!