Calculate distance in Microsoft Excel using latitudes and longitudes.
How to calculate straight line distance between two points in excel using latitudes and longitudes.
The big long formula is:
=6371*ACOS(COS(RADIANS(90-D7))*COS(RADIANS(90-D8))+SIN(RADIANS(90-D7))*SIN(RADIANS(90-D8))*COS(RADIANS(E7-E8)))/1.609