linear interpolation

[jray]

I have to calculate interest rates for dates between posted dates

My bank has given me the following.

The rate on 05/17/2017 is 3.7973%.
The rate on 08/15/2017 is 3.7235%.

The requested date is 07/15/2017 and the bank interpolated the rate to 3.7482%.

I need a formula where I have three dates and 2 rates, and I can interpolate the missing rate.

Any clues?

Thanks a lot.

jray

 

[jolivanes]

Is this close to what you need?

A7 = 5/17/2017, A8 = 8/15/2017, A9 = 7/15/2017, B7 = 3.7973, B8 = 3.7235, B9 = "=(A9-A7)*(B8-B7)/(A8-A7)+B7"

HTH

John

 

[jray]

This is not close to what I need, it is EXACTLY what I need!!!

Thank you very much!!!