Locate cell based on date

[barryeee]

I have a spreadsheet that has in row one dates of each Friday. Each week a calculation is done below that, that results in changing amounts. The problem is how to have another cell pick up the value of a cell based on a date once that day has passed but not gone beyond the next Fridays date.

Cell B2 this week should pick up cell K4, after Friday the 17/4//2015 cell B2 should then pick up cell L4 and rolling each week.

Friday.JPG

[NeedForExcel]

Please attach a sample excel workbook

[barryeee]

This is an example of the speadsheet
friday.xlsx