Andrew--not only is Ron's suggestion prettier, it also is easier to audit in
the future. Definitely go with it instead of my response.

Dave
--
Brevity is the soul of wit.


"Andrew Mackenzie" wrote:

Thanks very much Dave and Ron.

Ron, yours seems a prettier solution and it seems to have worked with a
brief test. However, I am curious to know why we add 29 rather than 30 to
my start date. Can you enlighten me?

Thanks,
Andrew.
"Andrew Mackenzie" wrote in message
...
I would appreciate any help that anyone can give with this problem.

I have a column of dates and next to it I want to create a formula which
adds 30 calendar days and if the result is a weekend or national holiday
then the result I want is the next good working day.

Help please!