Subtracting time in date format
 

Yes you are correct.

I have a column of due dates (all different) and I need to subtract the
allowed assignment time (8 weeks/40 days), not counting weekends.

So I want to calculate the start date for the assignments.

// Coolcat


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

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