Found another solution through this thread:
http://excelforum.com/showthread.php...d=1#post992503

=$A$1+IF(B1=0,0,SIGN(B1)*SMALL(IF((WEEKDAY($A$1+SI GN(B1)*(ROW(INDIRECT("1:"&ABS(B1)*10))),2)<4)*ISN A(MATCH($A$1+SIGN(B1)*(ROW(INDIRECT("1:"&ABS(B1)*1 0))),0,0)),ROW(INDIRECT("1:"&ABS(B1)*10))),ABS(B1) ))

confirm with control shift enter

A1 is the date, B1 is the number of days to add.



Mangesh


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=373356