NETWORKDAYS function with holidays and vacation days list

[Beneindias]

Hi guys,

Already tried search, but could not find an answer to my question.

Is there a way to have the function NETWORKDAYS to use two list, one of holidays and another one of vacation days?

I could not find an answer to this question, so, I think I will have to use only one list of "holidays + vacation days", but it would be much better to have those dates in two separated lists, for easy of use.

So, my question, is:
Can I use something to use two lists of dates as the last argument of the networkdays function?

Thanks in advance to all of you

 

[Beneindias]

Ok, found the solution.

I used the new function VSTACK, to combine Holidays and Vacation Days as last argument to NETWORKDAYS function.

It worked realy well for what I needed.

 

[Fluff]

You could use something like

=NETWORKDAYS(A2,A3,VSTACK(H2:H10,J2:J10))

 

[Beneindias]

You could use something like

=NETWORKDAYS(A2,A3,VSTACK(H2:H10,J2:J10))

@Fluff, thats exactly what I used.

Didn't knew that function before, and only found about it when I started looking for a way to combine arrays.

Thank you for your help

 

[Fluff]

Yup, noticed you had sorted it after I posted. Glad you found your own solution.