Filter excel

Hi Team,
I have attached the excel. From the attached excel column “Successfully Reconciled Holding as of File Date”, i want all data which date has been greater than t(system date)-7.
And that data needs to be pasted in same excel but in different tab.
Original data also be present in excel.sush.xlsx (39.8 KB)

Pls help me out


If the Date column is of type “Datetime/Date” . You can use Filter datatable.

i have tried but its not working, thats why raise in a forum

Hi ,

Excel Filter date - Copy.xaml (9.1 KB)
Can you try using this.