Hello everyone,
I'm doing an excel macro, everything is good except one point that I can't find the solution for.
The macro is on a file that I run once a week (on Wednesdays), every week.
I put a picture below to understand my explanations:
Basically: if the cell in the blue column is empty, the red column must be taken into account. On the opposite, if a date is in the blue column, it is the one that must be taken into consideration.
The green column is simply a "if" function to get the date as I explained above.
What I need: to have the date automatically filtered (with my macro) to the date of day -2 and before. So I'm going to run my file on Wednesday, I'll need the date (so the one to take into account as I explained before) to filter to Monday and all the other days before as well.
To understand a little better my filter history: it's as if I put a chronological filter with "before" and then "before or equal to..." and with the date of Monday.
Thank you very much in advance.
I'm doing an excel macro, everything is good except one point that I can't find the solution for.
The macro is on a file that I run once a week (on Wednesdays), every week.
I put a picture below to understand my explanations:
Basically: if the cell in the blue column is empty, the red column must be taken into account. On the opposite, if a date is in the blue column, it is the one that must be taken into consideration.
The green column is simply a "if" function to get the date as I explained above.
What I need: to have the date automatically filtered (with my macro) to the date of day -2 and before. So I'm going to run my file on Wednesday, I'll need the date (so the one to take into account as I explained before) to filter to Monday and all the other days before as well.
To understand a little better my filter history: it's as if I put a chronological filter with "before" and then "before or equal to..." and with the date of Monday.
Thank you very much in advance.