That is very true Ron, and must be for the reason you state. I will add that
to the text in future.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Ron Rosenfeld" wrote in message
...
On Thu, 11 Aug 2005 20:50:53 +0100, "Bob Phillips"
wrote:


=start_date+IF(days=0,0,SIGN(days)*SMALL(IF((WEEK DAY(start_date+SIGN(days)*
(

ROW(INDIRECT("1:"&ABS(days)*10))),2)<7)*ISNA(MATC H(start_date+SIGN(days)*(R
O

W(INDIRECT("1:"&ABS(days)*10))),holidays,0)),ROW( INDIRECT("1:"&ABS(days)*10
)
)),ABS(days)))

start_date, days, and holidays are named ranged here.

It is an arary formula so commit with Ctrl-Shift-Enter

Your formula is handy, but will give a REF error if days6553. I believe
that
is because the ROW(INDIRECT("1: ...) gives a result of greater than 65536
for
the second factor, which would result in an invalid cell reference.


--ron