Using WORKDAY function

[Frik]

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?

 

[Rick Rothstein \(MVP - VB\)]

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?

I am not sure what problem you are describing. If you pass in 0 for the DAYS
argument, the WORKDAY function returns the STARTDATE (which is the day zero
days away from itself).... holidays and weekends do not come into play when
the DAYS argument is zero.

Rick

 

[Frik]

Hi, I would be importing third party information from a spreadsheet from
outside South Africa. The dates in my spreadsheet would then be updated to
the next working day (taking weekends and our holidays into consideration).
Due to time lags & other delays before updating my info I foresee instances
where there is zero DAYS from the STARTDATE...yet I wanted the next workday
date after considering weekends / holidays. The formula I'm using works...al
be it based on "taking chance". I merely want to understand the functioning
of the WORKDAY function better & know whether there are alternatives. Thanks

 

[Rick Rothstein \(MVP - VB\)]

Hi, I would be importing third party information from a spreadsheet from

outside South Africa. The dates in my spreadsheet would then be updated
to
the next working day (taking weekends and our holidays into
consideration).
Due to time lags & other delays before updating my info I foresee
instances
where there is zero DAYS from the STARTDATE...yet I wanted the next
workday
date after considering weekends / holidays. The formula I'm using
works...al
be it based on "taking chance". I merely want to understand the
functioning
of the WORKDAY function better & know whether there are alternatives.
Thanks

I'm not sure what you want us to tell you... it is a mathematical certainty
that adding zero units (whether they be days, kilograms, pennies, etc.) to
some starting value will simply give you back the starting value.... X+0=X
no matter what X is. The WORKDAY function is not flawed when it does that.

Rick

 

[Ron Rosenfeld]

Hi, I would be importing third party information from a spreadsheet from
outside South Africa. The dates in my spreadsheet would then be updated to
the next working day (taking weekends and our holidays into consideration).
Due to time lags & other delays before updating my info I foresee instances
where there is zero DAYS from the STARTDATE...yet I wanted the next workday
date after considering weekends / holidays. The formula I'm using works...al
be it based on "taking chance". I merely want to understand the functioning
of the WORKDAY function better & know whether there are alternatives. Thanks

If you always want to ensure that if STARTDATE is Not a WORKDAY that it will be
adjusted to the next WORKDAY, you must use the solution you came up with:

=WORKDAY(STARTDATE-1,1)


--ron