# linear interpolation

#### jray

##### New Member
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

##### Well-known Member
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

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

Thank you very much!!!

1,081,899
Messages
5,361,928
Members
400,666
Latest member
UDLearning

### This Week's Hot Topics

• populate from drop list with multiple tables
Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
• Find list of words from sheet2 in sheet1 before a comma and extract text vba
Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
• Dynamic Formula entry - VBA code sought
Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...