Subtracting time in date format

C

Collcat

Yes you are correct.

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

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

// Coolca
 
A

anilsolipuram

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subtracting time...again 2
Subtracting time in date format 1
Display weeks from a Milestone 0
Help with a formula for a Time Sheet. 1
Subtracting time in date format 1
Help? I need help in making formulas work to accomplish... 0
subtract one cell from each cell in a range and count instances 2
Cobditional Formatting Rows based on dates in action plan. 0

Top