Forum Discussion
Calculating Distance between two points using Geography as Data Type in Excel
Hi- Can you calculate mileage between two cities using the "Geography" tool in the data types section in the data ribbon? I would like to create a mileage driving chart for about 20 cities. ...
Do not forget to convert the angles to radians before calculating sines or cosines. Also, it is unlikely that the curvature of the Earth is going to affect the distances you drive that much, the deviations from the straight line route required to follow the highway are far more significant.