I am using DATE & WORKDAY to show working days between activities in a
project plan I am preparing. So that the function can consider public
holidays and other non-working dates, I want to build an array constant that
contains the dates in question. The WORKDAY function can then refer to this
array constant for its calculations.

My question is: How do I set up an array constant based on the holiday
dates I want to use?

I want to use an array, rather than just a range of cells with the dates in
them.

I'm using Excel 2002 (10.6501.6735) with SP3. Windows XP Professional
(Version 2002) SP2.

Thanks in advance.

Regards,

Cliff