Filter Data Last 30, 60, 90 Days

treopro001

New Member
Joined
Nov 26, 2017
Messages
8
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!


[TABLE="width: 316"]
<colgroup><col></colgroup><tbody>[TR]
[TD]8/17/2014 6:22[/TD]
[/TR]
[TR]
[TD]3/1/2015 6:10[/TD]
[/TR]
[TR]
[TD]11/29/2015 21:53[/TD]
[/TR]
[TR]
[TD]6/2/2016 13:12[/TD]
[/TR]
[TR]
[TD]6/9/2017 15:19[/TD]
[/TR]
[TR]
[TD]10/21/2017 9:51[/TD]
[/TR]
</tbody>[/TABLE]
>=30
31>=60
61>=90
91>=
 

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.
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?
 
Upvote 0
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.
 
Last edited:
Upvote 0
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!
 
Upvote 0

Forum statistics

Threads
1,223,911
Messages
6,175,326
Members
452,635
Latest member
laura12345

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top