Working days
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
|