To get Google Maps distance between two coordinates simply use the same GetDistance function as above and replace the start and dest parameters with the coordinates in this format. As the process for getting Bing Maps API key is easy lets assume that is what you have. Get the Total Distance The lookup formula from cell C5 is copied down to C9 to calculate the distance for each leg of the trip.
Chris Venesss page also contains an Excel formula of the Haversine equation actually using the spherical lawof cosines for distances between points in kilometres.
Eg if the 1st address is in A1 and the second address is in B1 the formula would be. For example you can calculate age in years months and days. Even if you were to substitute it with the radius of a sphere assuming the Earth is spherical at 34377468 NM you will not be near the real accurate distance. Excel VBA Calculate d.
