garypea123
Board Regular
- Joined
- Mar 16, 2020
- Messages
- 221
- Office Version
- 365
- Platform
- Windows
Good Morning All,
Hopefully a simple one but I am looking to create an auto-filter which will only return results for anything in the last 365 days (A rolling list so to speak)
Below is a very simplified table
In F2 I have put =FILTER(B2:D4,B2:B4<365,) which is always going to be wrong as it would not understand the 365 as being days. But hoping somebody can tell me the correct way to write this.
Hopefully a simple one but I am looking to create an auto-filter which will only return results for anything in the last 365 days (A rolling list so to speak)
Below is a very simplified table
In F2 I have put =FILTER(B2:D4,B2:B4<365,) which is always going to be wrong as it would not understand the 365 as being days. But hoping somebody can tell me the correct way to write this.