Distance between two zip codes using Excel

Does anyone know how, via VBA or an advanced formula/function in Excel, to calculate the distance between two zip codes, if given the latitude and longitude coordinates like those on the attached?
Who is Participating?
AmickConnect With a Mentor Commented:
In miles:

=ACOS(COS(RADIANS(90-Lat1)) *COS(RADIANS(90-Lat2)) +SIN(RADIANS(90-Lat1)) *SIN(RADIANS(90-Lat2)) *COS(RADIANS(Long1-Long2))) * 3958.756

Source: http://bluemm.blogspot.com/2007/01/excel-formula-to-calculate-distance.html
leptonkaConnect With a Mentor Commented:
In this Linkedin discussion there were some other solutions about calculation distance between zip codes:
BBluAuthor Commented:
Thank you both very much. Awesome solutions!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.