rate based on date

Column A is a list of months: 1/1/2009 thru 1/1/2015.
Column B has a corresponding interest rate based on user inputs.

There are 5 user inputs:

Rate: 5%
Rate Increase: 0.5%
Increase Date:6/1/09
Increase End Date: 10/1/09
Increase Frequency(months): 2

The formula would evaluate each row date against the user inputs and produce an interest rate in column B.

1/1/09 = 5.0%
2/1/09 = 5.0%
3/1/09 = 5.0%
4/1/09 = 5.0%
5/1/09 = 5.0%
6/1/09 = 5.5%
7/1/09 = 5.5%
8/1/09 = 6.0%
9/1/09 = 6.0%
10/1/09 and beyond = 6.0%

thanks in advance,

matt

Matt, if we assume:

-- dates are listed in A2:A74 (A2 being Jan 09 and A74 Jan 15)
-- rates to be listed in B2:B74

Inputs as follows:

D2: Start Rate %
D3: Increase %
D4: Start of Increase (date)
D5: End of Increase (date)
D6: Frequency of Increase (integer, months)

Then based on your example:

Please Login or Register  to view this content.

copied down to B74

(note this is based on premise that End month does not have increase applied... see your ex. where Oct did not increment to 6.5%)


EDIT: I did not note before posting your title - please avoid using phrases like Formula Help etc... keep the title specific to the problem (I have amended on this occasion)

Thank you for the help, title verbiage noted. Is there a way to modify so I can leave the increase end date blank?

If you wanted to leave end date as blank you could alter slightly per below (alteration highlighted in red for ref.):

Please Login or Register  to view this content.