index or sumproduct for date

[jw01]

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.

[chrispittelli]

Is this what your looking for?

[Ace_XL]

Perhaps do away with your refernce tables altogether and use this..

Please Login or Register  to view this content.