macro to filter to a date 2 or 3 days ago

Hi i wonder if anyone can help, i have a macro i run to tell me what jobs were completed the day before. The code in the macro for that is simply:

ActiveSheet.Range("$A$2:$BV$198081").AutoFilter Field:=11, Criteria1:= _
xlFilterYesterday, Operator:=xlFilterDynamic

however on a Monday, i need to know what work was completed on a Friday, Saturday and Sunday. Ideally i need to bring each day back separately but using the code above will only tell me what was done on a Sunday.

I've tried using various combinations of yesterday - 1, Date -2 etc, but i just keep getting errors.

If i change the code to specify an actual date it works, but would rather not have to adapt the macro every week. Is there a way i can have a macro to tell me Friday's work (ie date -3 if ran on a Monday) and Saturdays work (date - 2).

Can anyone point me in the right direction please?

Thanks