Distance between Latitude and Longitude in Excel

FasasiOlalemiola2biz 

Worksheet formula
= GreatCircDistλ(origin, destination)

GreatCircDistλ
=LAMBDA(p₁, p₂, 
    LET(
        ϕ₁, RADIANS(p₁.[latitude]),
        λ₁, RADIANS(p₁.[longitude]),
        ϕ₂, RADIANS(p₂.[latitude]),
        λ₂, RADIANS(p₂.[longitude]),
        r,  6378,
        r * ACOS(SIN(ϕ₁)*SIN(ϕ₂) + COS(ϕ₁)*COS(ϕ₂)*COS(λ₂-λ₁))
    )
)