Custom Date Filter in Excel

[mssbass]

Using Excel 2013, is there a way to create a custom date filter to filter all dates that are >90 days ago: >today()-90. When I type this into the custom filter formula, it isn't working.

 

[Yongle]

one way is to use conditional formatting on the column to colour the data and then filter by colour

With dates in column A
conditionally format column A with this formula
=A1<(TODAY()-90)
I used RED to colour format the font

Excel 2016 (Windows) 32 bit

	A​
1​	DATE
2​	15/08/2019​
3​	05/08/2019​
4​	26/07/2019​
5​	16/07/2019​
6​	06/07/2019​
7​	26/06/2019​
8​	16/06/2019​
9​	06/06/2019​
10​	27/05/2019​
11​	17/05/2019​
12​	07/05/2019​
13​	27/04/2019​
14​	17/04/2019​
15​	07/04/2019​
16​	28/03/2019​
17​	18/03/2019​
18​	08/03/2019​
19​	26/02/2019​
20​	16/02/2019​

Sheet: Sheet11

Next..
- click on filter arrow at top of column
- click on Filter By Color and select RED

 

[Yongle]

Or use Advanced Filter
https://www.ablebits.com/office-addins-blog/2016/09/07/excel-advanced-filter/