andydavies14
New Member
- Joined
- Jul 31, 2024
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
I have Date & Time in the format ="03/09/2024 10:24 am" and I want to remove the Time so that I can filter by date
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Separating Date & Time
- Thread starter andydavies14
- Start date
6StringJazzer
Well-known Member
- Joined
- Jan 27, 2010
- Messages
- 3,658
- Office Version
- 365
- Platform
- Windows
- Mobile
Create another column using the formula
to truncate the time, and use that new column for filtering.
Or do you want to modify your actual data to remove the time?
Excel Formula:
=INT(A1)Or do you want to modify your actual data to remove the time?
Upvote
0
