Floating/variable interest rate formula

[excel-lerate]

I need a formula to calculate the interest rate of an investment from any given date in the past to the current date. I need to do so for an investment where the rate often changes. For instance, like the quarterly changes to the Federal Reserve or bank's prime lending rate. Any idea how to do this?