Subtracting time in date format
 

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

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