View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Adams135
 
Posts: n/a
Default Formula for Mileage from Latitude and Longitude

I finally got a list of all zip codes with the Latitude and Longitude of each.

I am looking for an Excel formula I can use to determine mileage between 2
zip codes based on their Latitude and Longitude. I have found several but
have been unable to get them to work in Excel. The following is an example
of what I have to work with.

Zip Latitude Longitude
23219 37.541696 -77.439204 Richmond VA

20315 38.928861 -77.017948 WASHINGTON DC

Any and all help/assistance will be greatly appreciated.

Thanks