If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

MILESBETWEENCITIES

Thread starter MrExcel
Start date Dec 9, 2020

=MILESBETWEENCITIES(From,To)

From: A cell containing a geography or location data type

To: A cell containing a geography or location data type

MILESBETWEENCITIES calculates the miles between two geography data types. Each data type must support the latitude and longitude field.

MrExcel

.

Builders Club Member

Dec 9, 2020

MILESBETWEENCITIES will calculate the miles between two geography data types. Each data type must support the latitude and longitude field.

Excel Formula:

=LAMBDA(From,To,(3959*2)*ASIN(SQRT(0.5-COS((To.Latitude-From.Latitude)*PI()/180)/2+COS(From.Latitude*PI()/180)*COS(To.Latitude*PI()/180)*(1-COS((To.Longitude-From.Longitude)*PI()/180))/2)))