Hi All,
I need to make a quick schedule to calculate shipping and processing times for my business.
My schedule contains multiple stages that differ in their time period, so I would like to have something that can calculate when all tasks need to be completed by in order for my shipping to arrive by the required date.
For example:-
Finalize artwork: (make payment-1 day)
Make payment: (commence printing-3 days)
Commence printing: (finish printing-2 days)
Finish printing: (goods pick up-2 days)
Goods pick up: (commence shipping-3 days)
Commence shipping: (arrival in port-14 days)
Arrival in Port: (customs release-7 days)
Customs Release: 22/12/17
I want to have this built to work backwards so that I can simply designate a date for my goods to arrive and automatically have the dates required to complete the steps until then. If it is possible to have excel skip over weekends this would be even better.
Thanks a lot!!
I need to make a quick schedule to calculate shipping and processing times for my business.
My schedule contains multiple stages that differ in their time period, so I would like to have something that can calculate when all tasks need to be completed by in order for my shipping to arrive by the required date.
For example:-
Finalize artwork: (make payment-1 day)
Make payment: (commence printing-3 days)
Commence printing: (finish printing-2 days)
Finish printing: (goods pick up-2 days)
Goods pick up: (commence shipping-3 days)
Commence shipping: (arrival in port-14 days)
Arrival in Port: (customs release-7 days)
Customs Release: 22/12/17
I want to have this built to work backwards so that I can simply designate a date for my goods to arrive and automatically have the dates required to complete the steps until then. If it is possible to have excel skip over weekends this would be even better.
Thanks a lot!!