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))

Find more posts tagged with

Accepted answers

Hollie Green

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

All comments

Hollie Green

Networkdays will give you the number of days between two dates based on your project settings excluding anything you have as a non-working day.

=NETWORKDAYS(Date@row, [Next Date]@row)

VanessaA

Thanks @Hollie Green - i only have dates set from start date and finish date, is there a way to create a formula to automatically identify Sunday and Holidays and remove that from day count?

Hollie Green

If you go into your project settings the below article walks you through how to set it for your sheet. The Networkdays formula automatically excludes it from the number of days between the start date and the finish date.

https://help.smartsheet.com/articles/765755-modifying-project-settings

It won't automatically figure out when the holidays are because different companies do different holidays so you will have to input your holiday dates.

VanessaA

@Hollie Green am i reading this wrong as it says it automatically excludes the weekend but I need it to include Saturday and only exclude Sunday. Sorry as usually i'm good with formulas but struggling with this one!

Hollie Green

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.