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

Jeremy Gordon

Hi,

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

I have 2 sheets:

1. The destination sheet is where I'm building the NETWORKDAYS w/ holidays formula
2. 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"))

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!