How to Calculate the Distance Between Two Coordinates in Excel In an example of how to calculate the distance between two coordinates in Excel, we’ll seek to measure the great circle distance. We’ll note that latitude and longitude are denoted in degrees, minutes and seconds. Convert Latitude...
This uses the ‘haversine’ formula to calculate the great-circle distance between two points – that is, the shortest distance over the earth’s surface – giving an ‘as-the-crow-flies’ distance between the points (ignoring any hills they fly over, of course!). ...
How to calculate distance in Excel from Latitude and Longitude. Download sample file with code base on Vincenty's formula.