backwards scheduling?

**scalin** · 04-25-2014, 04:04 PM

I have in mind to do a sort of “backwards scheduling”.

I know when I have to have something ready, see below:

Cell A1 shows the date/time in a specific format: ddd dd mmm yyyy hh:mm
Cell B1 shows the work duration to have the job done. This could be formatted as decimal.

The working hours are Mon-Fri 7:00 to 15:30.
I am thinking I have to create a calendar where I can exclude the Weekends and statutory holidays

If the delivery date is Mon 8:30 AM and the work duration is 6 Hours (0.706 working day) it means I have to start previous Friday around 11AM.

Cell C1 should have the calculated date when I have to start the job to be ready by the delivery date.
Anybody has any idea how this formula should look like?
Thank you in advance.

**tuph** · 04-28-2014, 02:30 AM

It would be best for you to attach a copy of your workbook so we don't have to try and replicate what you've already done. Remember to remove/replace any sensitive data before uploading.