Networkdays and multiple holiday ranges

[bk1]

Hi,
Is there a way to specify discontigous ranges for the Holidays parameter when I am not specifying them as a constant. I tried:
=NETWORKDAYS(G5;H5;Geirkalender) where GeirKalender is defined as:
=Geir;Vacation that is to separate ranges.

But all I get is "VAlue error"

 

[pgc01]

Hi

You cannot specify directly a non-contiguous range form the Holidays.

If you really need to do it, you can use an array formula, converting the non-contiguous range into a contiguous array, like:

=NETWORKDAYS($A$2,$A$3,LARGE((Geir,Vacation),ROW(INDIRECT("1:"&ROWS(Geir)+ROWS(Vacation)))))

This is an array formula, you have to confirm it with CTRL+SHIFT+ENTER.

Remark: I assumed Geir and Vacation are vertical vectors.

 

[bk1]

wonderfull!! I learned a good trick there!