On Mon, 18 Jun 2007 23:13:00 -0700, Frik
wrote:

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