Thank You
Good stuff.

I see one problem though. Due to me selecting 8 weeks for the example.

Lets say my due date is 11/9/04, 8 am and I have 3 days (72 hours) to
complete the assignment and I can't work on weekends.

According to the formula I should start on 11/6. Now 11/6 is on a
Saturday!
So I need the formula to skip the weekend days when it is calculating
backwards to the start date.

Any ideas?

// Coolcat


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