The Haversine Formula calculates the distance between two points on a sphere, considering the curvature. It is an accurate method for calculating the distance between two sets of coordinates, taking Earth’s curvature into account. [1][2]
S = Distance between two addresses
r = Radius of Earth
1 = Latitude of the first place
φ2 = Latitude of the second place
ℽ1 = Longitude of the first place
ℽ2 = Latitude of the second place
See the formula in use:
- Calculate the distance between two coordinates in Excel
- JavaScript & the Geolocation API
- Calculate the distance between two coordinates in VBA
References:
- vCalc.com (No date). Haversine – Distance. Available at: https://www.vcalc.com/wiki/vCalc/Haversine%20-%20Distance (Accessed: 7 July 2024).
- Nahian, M. A. (2024) How to Calculate Distance Between Two Addresses in Excel (3 Ways), ExcelDemy. Available at: https://www.exceldemy.com/calculate-distance-between-two-addresses-in-excel/ (Accessed: 7 July 2024).