Every 6 mos, the interest rate in my model changes. I want Excel to search a
column containing a list of 6-month ranges of dates, such as, 1/1/99 to
6/30/99; next, 7/1/99 to 12/31/99; next 1/1/00 to 6/30/00; next 12/31/00, and
so on for several years. Then return the interest rate specified next to the
date range within which a particular date specified in another cell falls.