no matter what i do with your code i don't get right date in filter
i work from Monday -Friday or sometimes Monday-Saturday
i would like to get code that I CAN RUN on Monday that would filter by Fridays date if Friday is the last working date for past week or Saturday if Saturday is the last working date for past week
but if i ran code on TUASDAY TO FRIDAY ,code would filter by one day before
in other words always filter by older date in that column (column A in my case)

Thanks for your help