Hi,
I have an excel sheet in which I have to filter the datatable on 2 points
- If status is ABC Completed.
- IF Current day is Monday than filter the Completion dates based on Friday,Saturday,Sunday.
Using the above filtering the datatable can be empty also if both the conditions do not match.
I have attached the excel sheet for the same.
Book1.xlsx (1.2 MB)
I have managed to solve for the Filtering of Status, but can anyone suggest on how to filter based on the above 2nd condition.