NETWORKDAYS using two different sets of holidays.

jg124

Hi,

 

Just wondering if its possible to use the NETWORKDAYS formula using two different sets of holidays, based on whether testing site is Munich or Sydney. I have the holiday dates listed in separate columns e.g

 

=IF([Testing Site]10="Munich", NETWORKDAYS(start_date,end_date,munichHol1:munichHol13),  IF([Testing Site]10="Sydney", NETWORKDAYS(start_date,end_date,sydneyHol1:sydneyHol13))

 

When I try this formula I keep getting an error

 

Thanks

L_123

It is possible. Make sure you only have dates inside of the range you reference, and that they are formatted as date type. If you have a dynamic list, it might be better to use the collect formula to parse out any blanks or non-date numbers

jg124

Thanks for reply. Got it sorted!