try this


startdate=IF(B4<5,IF(WEEKDAY(B4)=7,A4-1-B4,IF(WEEKDAY(B4)=1,A4-2-B4,IF(B4-WEEKDAY(B4)<2,A4-2-B4,A4-B4))),IF(WEEKDAY(A4)=1,A4-2-INT(B4/5)*7-MOD(B4,5),IF(WEEKDAY(A4)=7,A4-INT(B4/5)*7-1-MOD(B4,5),A4-INT(B4/5)*7-MOD(B4,5))))


a4 is due date and b4 is number of working days needed to complete the
assignment.


--
anilsolipuram
------------------------------------------------------------------------
anilsolipuram's Profile: http://www.excelforum.com/member.php...o&userid=16271
View this thread: http://www.excelforum.com/showthread...hreadid=277036