Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically enter date and time but only update once. | New Users to Excel | |||
How do I format column containing date and time to only show the . | Excel Discussion (Misc queries) | |||
Subtracting time in date format | Excel Worksheet Functions | |||
Subtracting time in date format | Excel Worksheet Functions | |||
Subtracting time in date format | Excel Worksheet Functions |