NETWORKDAYS

[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.

 

[Trevor Shuttleworth]

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

 

[JS]

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

 

[Myrna Larson]

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).