A4 is the due date
startdate =IF(WEEKDAY(A4)=0,A4-2-56,IF(WEEKDAY(A4)=7,A4-1-56,A4-56))
56= 8weeks * 7 days
solution does not include the weekends as you said
Let me know if you got it.
--
anilsolipuram
------------------------------------------------------------------------
anilsolipuram's Profile:
http://www.excelforum.com/member.php...o&userid=16271
View this thread:
http://www.excelforum.com/showthread...hreadid=277036