Never mind; additional testing is revealing an original
misunderstanding;;;
Thanks,


"JMay" wrote in message
:

With A1:A4 holding:

11/27/2006
11/28/2006
11/29/2006
11/30/2006

When I enter in B1 and Copy down

=WORKDAY(A1+29,1,Holidays)

I get in B1:B4:

12/27/2006
12/28/2006
12/29/2006
01/01/2007 <<< Not sure why this one?? Any ideas what's going wrong?

My Holiday range only includes 10/31/2006 and 12/25/2006 (2 cells)

Thanks,





"Ron Rosenfeld" wrote in message
:

On Wed, 3 Jan 2007 11:24:58 -0000, "Andrew Mackenzie"
wrote:

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!



=WORKDAY(A1+29,1,holidays)

Holidays is a named range with a list of your holidays.

If the WORKDAY function is not available, and returns the #NAME? error, install
and load the Analysis ToolPak add-in.

On the Tools menu, click Add-Ins.
In the Add-Ins available list, select the Analysis ToolPak box, and then click
OK.
If necessary, follow the instructions in the setup program.

--ron