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)*(RO
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
|