NETWORKDAYS using two different sets of holidays.

jg124
jg124 ✭✭✭✭✭
edited 12/09/19 in Smartsheet Basics

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

Comments