Hi

I need help to calculate shipment, request date, picking, weekends, national holidays and change the request date in every 3 months. I've already accomplish some but I still need help to finish it (please see the attachment).

Logistic v1.1.xlsx.zip

The purpose is to manage 15 routes (with two route having two paths) with the following data:
a) There is a shipment every 60 business days (retrieving the national holidays and district holidays)
b) A limit date so the manager of which route can do the request
c) A deadline date to emit the request for each route
d) Every 3 months the distribution date must be 5 or 6 business days before. So the deadline to emit the request and the deadline to handle the merchandise must also change the days (back)
e) Calculate the deadline for picking based on the deadline to emit the request (nš of business days)
f) Calculate the deadline to delivery based in the last day of picking

Best Regards
Richard