Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
NETWORKDAYS
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
NETWORKDAYS
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 "ChrisG" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
NETWORKDAYS
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
NETWORKDAYS
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). On Wed, 23 Jul 2003 13:50:13 -0700, "ChrisG" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
networkdays | Excel Discussion (Misc queries) | |||
NETWORKDAYS #NAME? | Excel Discussion (Misc queries) | |||
NETWORKDAYS? Maybe not? | Excel Discussion (Misc queries) | |||
NETWORKDAYS | Excel Worksheet Functions | |||
networkdays | Excel Worksheet Functions |