Road distance calculation using latitudes and longitudes

I'm looking to get road distances between 2 addresses. I have the latitude and longitudes of each address. The issue I have is I can't use the Haversine formula, as it's for mileage claims so needs to be road distances.

I'm aware of the google API stuff, but not really sure how it works, or how I'd go about implementing something like that into my scripts.

Can you please help me on this.

https://www.excelforum.com/tips-and-...ml#post2678041