software

I am using DATE amp; 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

You can use an array constant like so

=WORKDAY(TODAY(),5,{quot;14/04/2006quot;,quot;17/04/2006quot;})

if that is what you mean, but a range is far more flexible.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;CliffDquot; gt; wrote in message
...
gt; I am using DATE amp; WORKDAY to show working days between activities in a
gt; project plan I am preparing. So that the function can consider public
gt; holidays and other non-working dates, I want to build an array constant
that
gt; contains the dates in question. The WORKDAY function can then refer to
this
gt; array constant for its calculations.
gt;
gt; My question is: How do I set up an array constant based on the holiday
gt; dates I want to use?
gt;
gt; I want to use an array, rather than just a range of cells with the dates
in
gt; them.
gt;
gt; I'm using Excel 2002 (10.6501.6735) with SP3. Windows XP Professional
gt; (Version 2002) SP2.
gt;
gt; Thanks in advance.
gt;
gt; Regards,
gt;
gt; Cliff
Bob,

Thanks for this; I'll try it later. I've re-read the help text I was
looking at, and the array constant works as long as the dates are converted
to their serial number format. This obviously makes setting up the array a
lot simpler and then by naming the array, it makes the task of pointing the
function to the correct range of cells a lot easier.

Thanks amp; regards,

Cliff

quot;Bob Phillipsquot; wrote:

gt; You can use an array constant like so
gt;
gt; =WORKDAY(TODAY(),5,{quot;14/04/2006quot;,quot;17/04/2006quot;})
gt;
gt; if that is what you mean, but a range is far more flexible.
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;CliffDquot; gt; wrote in message
gt; ...
gt; gt; I am using DATE amp; WORKDAY to show working days between activities in a
gt; gt; project plan I am preparing. So that the function can consider public
gt; gt; holidays and other non-working dates, I want to build an array constant
gt; that
gt; gt; contains the dates in question. The WORKDAY function can then refer to
gt; this
gt; gt; array constant for its calculations.
gt; gt;
gt; gt; My question is: How do I set up an array constant based on the holiday
gt; gt; dates I want to use?
gt; gt;
gt; gt; I want to use an array, rather than just a range of cells with the dates
gt; in
gt; gt; them.
gt; gt;
gt; gt; I'm using Excel 2002 (10.6501.6735) with SP3. Windows XP Professional
gt; gt; (Version 2002) SP2.
gt; gt;
gt; gt; Thanks in advance.
gt; gt;
gt; gt; Regards,
gt; gt;
gt; gt; Cliff
gt;
gt;
gt;