Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
In a formula I only wanted work days to be shown. I used the WORKDAY
function which worked fine until I reliased weekends and holidays were missed when the DAYS parameter was 0 (this value comes from a reference cell and determined by other occurences.). Out of despiration I tried using STARTDATE-1 and DAYS (x+1). That works fine...maybe not the right solution.... I still wonder why would the use of 0 as DAYS not function properly? Was this possiblity simply not forseen? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
WORKDAY function | Excel Worksheet Functions | |||
Using WORKDAY function | Excel Worksheet Functions | |||
Workday function | Excel Discussion (Misc queries) | |||
Workday function | Excel Worksheet Functions | |||
How do I get the WORKDAY function? | Excel Discussion (Misc queries) |