Subtracting time in date format

C

Collcat

Hi,
I have a column of due dates and times (format: 11/08/04 11:00).
weeks worth and all on weekdays.

I would like to calculate starting dates/times in the next column, bu
I need to take into account the weekends. You can't start th
assignment on a weekend or work on the assignment on a weekend.

So, I would like to take the due date/ time and subtract 2 days and
hours, but if the assignment time falls on a weekend, I need t
subtract full days until I get to a weekday. So that everybody has th
same amount of available to work on the assignment.

What would a formula look like that could do this calculation?

Thanks in advance
Coolca
 

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
Remove weekends 2
aging calendar days 2
Subtracting Dates with Empty Cells 3
How to calculate dates 6
problem with time subtraction 7
Counting depending on another column 4

Top