Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Filter data which has time date stamp



Could anyone guide me about how to Filter / Sort / vlookup or make Pivot based on Date if the Date cell contains Time stamp along with date. 

Eg : 2021-08-24 18:13:23, 2021-08-24 18:14:20  2021-08-25 10:09:23




You need to take care with date/time numbers but Don's tutorial Vlookup on Dates and Times in Excel should be enough to get you on the correct path.


Answer the Question

You must create an account to use the forum. Create an Account or Login