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 ..
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 ..