PivotTable filtering, how to check if a date exists, if not, then filter date -1

[Norbi7454]

Hi All.

I need to make a macro that filters the last 6 dates from the current date in a specific pivot table (run rate calculation).

The problem is that you have to omit Sundays + check if there was a sale on Saturday, if so, we count Saturday, if it wasn't, then the day before. So 2 possible scenarios:

1. today August 16 (Monday) - I have to filter 14, 13, 12, 11, 10, 09 - there was a sale on Saturday

2. today 16.08 (Monday) - I have to filter 13, 12, 11, 10, 09, 07 or 06 - there was a sale on Saturday - but on an earlier Saturday it is possible that the sale was or was not

I don't know how to go about it ..

 

[Norbi7454]

Refresh.

 

[Norbi7454]

Ktoś jest w stanie pomóc ?