Everything is based on the first 3 digits of a the Origin zip code and the first 3 digits of the destination zip codeĪ link to the spreadsheet can be found at What I want to create is the ability to type in two random zip codes in excel, and have there be a calculation done through to tell me what zone the shipment would be considered.
UPS and Fedex both have zone calculators available where I can type in my starting zip code, and the website will tell us based off of that initial zip what shipping 'zone' other parts of the country are in.