DMM,

So, if my end date is 12/19/08 and the previous operations calls for 4
hours, I need to schedule back 4 hours.
4 hours back from 12/19 may also be 12/19, depending on:

What time on the date?
Does your date have a time as well?
What is your standard workday - 24 hours, or 7AM to 5PM?
Do you need to account for lunch?
Is the difference always hours, or do you also need days? Weeks? Months?

Bernie
MS Excel MVP


"soconfused" wrote in message
...
I have an end date and need to schedule backwards.

So, if my end date is 12/19/08 and the previous operations calls for 4
hours, I need to schedule back 4 hours.
--
DMM


"Bernie Deitrick" wrote:

DMM,

So, do you have an end date, and want to calculate an earlier date that gives you a certain
number
of workdays?

Or do you have an start date, and want to calculate an later date that gives you a certain number
of
workdays?

Bernie
MS Excel MVP


"soconfused" wrote in message
...
L35 is a date. I'm trying to take a date and subtract out hours to get a new
date and I can't include weekends or holidays.

--
DMM


"Bernie Deitrick" wrote:

That would help, but how do I incorporate that into a formula like this:

L35-(E35/3-1).

=:-) ? Incorporate that how? What is in L35? in E35?

Bernie
MS Excel MVP