BrI
06-30-2017, 01:12 PM
Trying use Networkdays along with the Indirect function to pick up a range of holidays on the "HolidayTab" of a workbook. There are 10 different ranges of holidays in this tab and the range selected will depend on the value in column A in TabA.
Note, I am working in "TabB"
I have this function working if I reference the holiday ranges in a separate workbook (Holidays.xls) as below.
Working:
=NETWORKDAYS(TabA!E17,TabA!F17,INDIRECT("Holidays.xls!" &TabA!A17))
But I want to have the holiday ranges in a separate tab in the same workbook as TabA and cannot get this to work. Have tried variations on formula below but not working.
Not Working
=NETWORKDAYS(TabA!E17,TabA!F17,INDIRECT("HolidayTab!" &TabA!A17))
Can someone help with the syntax?
Note, I am working in "TabB"
I have this function working if I reference the holiday ranges in a separate workbook (Holidays.xls) as below.
Working:
=NETWORKDAYS(TabA!E17,TabA!F17,INDIRECT("Holidays.xls!" &TabA!A17))
But I want to have the holiday ranges in a separate tab in the same workbook as TabA and cannot get this to work. Have tried variations on formula below but not working.
Not Working
=NETWORKDAYS(TabA!E17,TabA!F17,INDIRECT("HolidayTab!" &TabA!A17))
Can someone help with the syntax?