Novice Needs Help with Formulas

Buidling our 2006 budget. My columns are as follows:

Column A - Name
Column B - Title
Column C - Beginning Year Payrate
Column D - Projected Increase (set at 3% above Column C)
Column E - Anniversary Date (when raise is due)
Column F - Actual Increase (to be computed on anniversary date)
Columns G - R Jan, Feb, Mar, etc

Essentially, I want a formula that will look at column G-R, compare it to Column E and then use either Column C or Column F.

Example: John Doe's anniversary is Mar 06. In column C, I have put his beginning year payrate of $35000. Column E has $36050. So, the columns labeled Jan and Feb should look at Column E, understand that Jan is less than the date in Column E and use the value in Column C. The same should be for Column H. When we get to Column I (Mar), the formula should recognize that Column E is equal or greater to Mar and then use the data in Column F. This would be followed for the remaining months.

On our current budget it is a manual process to copy and paste all the way through once raises are input.

Any help would be much appreciated!!