I need to filter the excel and below is the criteria:
Filter the records on Column A (Due Date) to contain the records with due date that are 7 days old. For example, if the current date is 11/05, select only the records with Due Date as 10/29. On Fridays, include records with due date 7 and 6 days old. And on Monday, include records with due date 8 and 7 days old.
Any help is much appreciated.