How do I get a range of values from another sheet to feed NETWORKDAYS w/ holidays formula?

Hi,

I'm super stumped on this one and can't find a solution.

I have 2 sheets:

The destination sheet is where I'm building the NETWORKDAYS w/ holidays formula
The source sheet is called "Shutdown Days" and has 2 columns - "Client" and "Date". See screenshot below.

I need to just pull the range of dates into the NETWORKDAYS formula where Client = "AXEL8".

While creating this post, I figured out the solution. I'm posting anyway for anyone else who bumps into this.

=NETWORKDAYS([DRYWALL START]@row, [DRYWALL END]@row, COLLECT({Shutdown Days - Date}, {Shutdown Days - Client}, "AXEL8"))

Find more posts tagged with

Accepted answers

All comments

Andrée Starå

Hi @Jeremy Gordon

I hope you're well and safe!

Glad you got it working!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Please support the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.