Link to home
Start Free TrialLog in
Avatar of Marcia Morris
Marcia MorrisFlag for United States of America

asked on

Formula for calculating number of weeks?

Hello, I am working on a spreadsheet that will tell our Inside Sales rep when an order will need to ship from our location in order to make it to Malaysia on time. For example if the shipment needs to be in Malaysia by 12/18/15 I want the formula to back out 10 weeks including weekends and holiday's (this will account for transit and customs). Some of the orders I will need to back out a different number of weeks ie., 6 weeks AND some of them I need to send to a 2nd location (and they need 3 weeks to do what they have to do) for another operation before it ships to the customer.
UTAS-RCC-SCI-Ship-Schedule.xlsx
ASKER CERTIFIED SOLUTION
Avatar of Rgonzo1971
Rgonzo1971

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Marcia Morris

ASKER

Worked like a charm!