On Wed, 3 Jan 2007 12:42:03 +0000, "JMay" wrote:

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,



If you don't have 1 Jan listed in your Holiday range, and it is not a weekend
day (Saturday Sunday), Excel cannot know that you want to consider it a
holiday.

1 Jan 2007 was a Monday.

--ron