Subtracting time in date format

  • Thread starter Thread starter Collcat
  • Start date Start date
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
 
Back
Top