I need to filter date in excel column from current date using linq

Help Studio
, ,
1

I have a list of date in excel column. My Excel sheet Date is in MM/dd/yyyy format.

If current date is (oct 2022), I need to filter list of 11 months date from current date in that excel column. (From Nov 2021 to Oct 2022)

If current date is (Oct 2022), I need to filter list of 10 months date from current date in that excel column. (From Dec 2021 to Oct 2022)

2

To use advanced date filters:
Select the Data tab, then click the Filter command. A drop-down arrow will appear in the header cell for each column.
Click the drop-down arrow for the column you want to filter.
The Filter menu will appear.
The worksheet will be filtered by the selected date filter.

Regards,
Will

3

Hi @lokeshkumar.k ,
Use macros for this.