Zip code to zip code distance calculator

[Abraham.lopez729]

Good Afternoon all,
I'm trying to figure out how to calculate distance between zip codes. I see a lot of post but trying to understand how its done or what formula or macro I use to calculate it. attached is what I'm trying to do. Any help would be great!

[hrlngrv]

More specs needed.

For what it's worth, I live 2 houses in from the town line, so 2 houses away from me is a different zip code. In my situation, the 2 zip codes could be said to be about 140 feet apart.

If you mean geometric center to geometric center, zip codes differ substantially in size. Zip code 89049 in Nevada is slightly larger than the state of Maryland, so also larger than 8 other states. Then there's Alaska. On the flip side, the smallest zip code is 2 city blocks in in one of the New York burroughs (no great surprise).

As far as I know, there is no simple formula for this. Even if you had latitude and longitude for the geographic centers to the hundredth of a second, it'd still be an awkward calculation.