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>=
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>=