This formula calculates the distance between 2 Lat/Long coordinates (A1,B1;A2,B2):
=ACOS(COS(RADIANS(90-A1))COS(RADIANS(90-A2))+SIN(RADIANS(90-A1))SIN(RADIANS(90-A2))COS(RADIANS(B1-B2)))6371*1000
The result in in meters.
