Hello,

I have looked and looked and I am now stumped. Help!

I want a percentage rate to populate into a cell based on a date entered in
another cell.

Example info:

07/01/87 - 12/31/94 = 12%
01/01/95 - 12/31/95 = 8%
01/01/96 - 12/31/96 = 10%

Date cell A1
Percentage rate cell A2

I type 02/01/95 into cell A1. I would like 8% to populate into cell A2.

Thanks!