Search 90 days back date data

[annadinesh]

Dear Experts

I have a Data Sheet where Purchase date is written on Column E All Cells

and Service Due Date is Written on F Column

I want a Vba code to filter F Coloumn for 90 Days Old Data from Purchase Date


Regards


Dinesh Saha

 

[Legacy 143009]

You said purchase date is written on all cells in Column E.
According to which date would you like to filter exactly?
Could you please provide sample data and sample result?

 

[annadinesh]

You said purchase date is written on all cells in Column E.
According to which date would you like to filter exactly?
Could you please provide sample data and sample result?

According to Todays Date, i want the list shows the data which are within 90 Days from purchase date.

REGD NO.	Sale Date	1ST FS
22BH6059C	25.07.2022	01.11.2022
WB74BL4161	29.08.2022​	01.11.2022
WB74BL6129	07.09.2022​	01.11.2022
WB74BL1823	08.08.2022	02.11.2022
WB74BL7900	03.09.2022​	02.11.2022
WB74BL8553	21.10.2022	02.11.2022
WB74BL4608	05.09.2022​	03.11.2022
WB74BL8552	21.09.2022​	03.11.2022
SK05P3718	12.08.2022	05.11.2022
WB74BL9767	21.09.2022​	05.11.2022
WB74BL4544	07.09.2022​	06.11.2022
AR02B4816	08.09.2022​	07.11.2022
AF161662	13.10.2022	07.11.2022
WB74BL2653	17.08.2022​	08.11.2022
WB74BL6339	25.08.2022​	08.11.2022
AF827788	31.08.2022​	08.11.2022
WB74BL5045	09.09.2022​	08.11.2022
WB74BL5005	09.09.2022​	08.11.2022
WB74BK8920	30.06.2022	09.11.2022
WB74BL9483	30.09.2022	09.11.2022
WB74BL5872	19.09.2022​	10.11.2022
AF354246	20.09.2022	10.11.2022
WB74BL5897	12.09.2022​	11.11.2022
WB74BL6324	12.09.2022​	11.11.2022
WB74BL5855	12.09.2022​	11.11.2022

 

[Legacy 143009]

I am not sure if it is doable with filters. Maybe hiding rows may work.