Filter Data Last 30, 60, 90 Days

[treopro001]

Hi Everyone,

Can someone point me in the direction on how to filter dates: In my excel sheet i have a list of users with the last logon time.
I would like to see/filter users on the last 30 days or before, Between 31-60 Days ago, and 60-90 days or more?



Username: LastLogonTime
BartSimpson 11/25/2015
HomerSimpson 3/1/2015
MargeSimpson 11/29/2017
Lisa Simpson 09/14/2017


Thanks for any help!

8/17/2014 6:22

3/1/2015 6:10

11/29/2015 21:53

6/2/2016 13:12

6/9/2017 15:19

10/21/2017 9:51

<colgroup><col></colgroup><tbody>
</tbody>

>=30
31>=60
61>=90
91>=

 

[treopro001]

Hi Mark,

Thanks for your help! I'll give this a go tmrw! Appreciate for all your help. Happy holidays!

 

[treopro001]

I couldn't sleep and tried to give this a go again. I looked online and some people are using conditional formatting.

I was able to get this going.
Conditional Formatting > New Rule > Format only cells that contain > Cell Value, less than, Today()-30> Choose a color.

How can I write a rule thats between 30 and 60 days as well as more than 61 < days?

 

[MARK858]

In one of the cells I cleared that and typed =ISNUmber(A5) and got a False. Btw the data that was generated was from Powershell that I ran.

Just reading this again, I didn't state clear any cells I said put the formula in an empty cell and change the A5 in the formula (although had a typo and was missing the A) to one the cells with a date. Hopefully you have done this correctly and not how you have responded above.

 

[treopro001]

Just wanted to say thank you for your help! I was able to use the conditional forwarding to highlight the conditions that was mentioned. Thx agaiN!