Look at the attached sample sheet.
How can I automatize, with 7 formulas or a macro, those 7 field in line 10 so that only the data of the week of the specified "Last day to show" is shown?
(as example I already filled the fields with the expected results for that given "Last day to show" 09/01/2014)