Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel's range Union operator in WORKDAY function gives #VALUE!.
I can not get the range Union operator to work with the Workday
function. See for example row 5 in the following: A B C D 1 Demonstration that Union operator does not seem to work with WORKDAY 2 function while the same expression does work with the SUM function. 3 2-Apr-02 4 37349 =WORKDAY(B3,1,$B$9:$D$10) 5 #VALUE! =WORKDAY(B3,1,$B$9:$D$9,$B10:$D10) 6 224830 =SUM($B$9:$D$9,$B$10:$D$10) 7 8 Holidays: In the following row, enter the common holidays after Apr 2, 2002 in successive cells. 9 20-May-02 28-Jun-02 1-Jul-02 10 17-Sep-02 23-Sep-02 24-Sep-02 11 Vacations: In the above row, enter the vacations The same problem occurs with the Networkdays function. On the other hand, the Sum function works with the same Union expression, as shown by row 6. Any explanations or solutions? Thanks for your help. Regards, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW DO i INSERT A RANGE OF SERIAL DATES IN THE WORKDAY FUNCTION | Excel Worksheet Functions | |||
How to use union reference operator? | Excel Discussion (Misc queries) | |||
Using Range operator (:) In If condition | Excel Worksheet Functions | |||
Why doesnt union reference operator work with COUNTIF? | Excel Discussion (Misc queries) | |||
union range | Excel Discussion (Misc queries) |