Bob, thanks for the help. Glad that did it for the OP. Admit I was lazy in
not testing out the simple front bolt-on. Just wondering why the simple:
=IF(A2="","",...) doesn't get accepted in this instance.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Bob Phillips" wrote:
=IF(OR(A2="",B$2=0),0,A2+SIGN(B$2)*SMALL(IF((WEEKD AY(A2+SIGN(B$2)*(ROW(INDIR
ECT("1:"&ABS(B$2)*10))),2)<6)*ISNA(MATCH(A2+SIGN(B $2)*(ROW(INDIRECT("1:"&ABS
(B$2)*10))),C$2:C$3,0)),ROW(INDIRECT("1:"&ABS(B$2) *10))),ABS(B$2)))

or perhaps

=A2+IF(OR(A2="",B$2=0),0,SIGN(B$2)*SMALL(IF((WEEKD AY(A2+SIGN(B$2)*(ROW(INDIR
ECT("1:"&ABS(B$2)*10))),2)<6)*ISNA(MATCH(A2+SIGN(B $2)*(ROW(INDIRECT("1:"&ABS
(B$2)*10))),C$2:C$3,0)),ROW(INDIRECT("1:"&ABS(B$2) *10))),ABS(B$2)))