Forum Discussion
Distance between Latitude and Longitude in Excel
How can I derive the distance between two points in Excel given Latitude and Longitudes?
How would you do it without Excel? That's not meant to be a dismissive question; rather, if I knew how to do it "on paper" or with pencil and paper and some other information on latitude and longitude lines and how they're determined in the first place, then I might be able to say how to do it with Excel.
My sense, though, is that it's not readily answered by just knowing, say,
and
If you can use formulas to tell us the distance between those two points, and tell us how you did it, I might be able to tell you how Excel could accomplish the same. Now, I happen to know the distance between those two points when driving by car, so I'll be able to determine whether your answer is plausible.