NETWORKDAYS

  • Thread starter Thread starter ChrisG
  • Start date Start date
C

ChrisG

I received a WS with the function NETWORKDAYS being used
as follows

=NETWORKDAYS(BO91,BU91,holidays)-1

where

BO91 = Start Date
BU91 = End Date
holidays = the header cell on a range of dates in another
worksheet.

my questions....How does the function know that holidays
is a range and how can I assess that condition.
 
Chris

From the menu select Insert | Name | Define. You should then see a dialogue
box listing all the named ranges.

holiday should be one of the ranges named and you should be able to then
view it. It could be on another sheet which may be hidden.

Regards

Trevor
 
it might be worth checking whether holidays is a named range - go to
Insert - Name - Define and see if holidays is in the list of named ranges
 
It doesn't "know", but if it isn't a named range, the formula will give an error. It should
refer to a multi-cell range (in a single row or column), not to the header cell only (unless you
have only 1 holiday).
 
Back
Top