distance between 2 coordinates

[6diegodiego9]

Consider this two point on the map:

[TABLE="width: 210"]
<tbody>[TR]
[TD="class: xl65, width: 116"]latitude[/TD]
[TD="class: xl65, width: 94"]longitude[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 116"]45.61782[/TD]
[TD="class: xl65, width: 94"]9.41737[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 116"]45.48568[/TD]
[TD="class: xl65, width: 94"]9.20181[/TD]
[/TR]
</tbody>[/TABLE]

The distance between each other is about 22km.
What's the formula to calculate that?

I tried different formulas found online but every one returned absurd values...

 

[6diegodiego9]

By the way, try to change your LAT and LON data as;

45,61782 and 9,41737

I mean; use comma (",") instead of dot (".") for the decimal point indicator..... which depends on your Excel settings.

Substituting the comma (",") with dot (".") solved the problem on my English-language Excel with Italian regional settings!
Thanks so much Haluk!!!

I also succesfully used =6371*((2*ASIN(SQRT((SIN((RADIANS(A2)-RADIANS(A3))/2)^2)+COS(RADIANS(A2))*COS(RADIANS(A3))*(SIN((RADIANS(B2)-RADIANS(B3))/2)^2)))))

Great! Thanksssssssss again!!!

 

[Haluk]

You are welcome