Sreekanth, This doesn't work.. let me create sample data for u to have better view of it.
I have attached the workbook. Please see.Dates-1
Dates-1 sales should get populated with last wednesday sale for selected date param. Thanks !
The reason for not working the formulas is you are filtering off
if you remove the filter, then fine
please find the attached workbook sheet 4 for your reference.