Filter excel with dates

Hi All,

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.

kindly have a view on this thread

Cheers @IshaSharma


Check the attached xaml, it may help you. Let me know if you need further details.
FilterExcelByDateCol.xaml (7.9 KB)

Thank you Sarathi. It worked.

1 Like

Thank you.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.