index or sumproduct for date

hello

I need a lookup or sumproduct or index formula that will give automatically make the date i select fall within a certain time frame.

For example, if the date is 15-Jan-2012, I want a formula to make the cell below make it "Jan 9-15"

I have the lookup data in the attached sheet, any help would be greatly appreciated.

the formula should go in cell D17.

thxs in advance.