Calculate inter-site distance

Hello,

Anyone with an excel macro or a method for calculating inte-site distance?

Admin note: this post was updated with image below.

Input the source and target lat long.

Distance sheet.xlsx.zip (7.0 KB)

1 Like

Another option:

Excel Distance_Calculator_LatLon.xlsb.zip (9.9 KB)

1 Like

This is for air distance, do you have any tool for map drive distance?

Hi! when i enter different Lat and Long of source and target cell values it’s showing me 0 at distance cell. what is the issue?