CODEWITHSUNDEEP
exceldatetypeshour
Luis de Souza
Luis de Souza

Reputation: 25

Turn text with date to date type

I've searched on the internet and couldn't find. The only solution I found was to download kutools, and I can't do it. I've made a macro that gets some values from an intranet, but I need the type of cell to be in date so I can work around it and filter it.

I don't know if I explained it correctly, and sorry if my english isn't the best. I made an image to better explain it.

How it currently is / How I want it to be:

enter image description here

Upvotes: 1

Views: 41

Answers (1)

BigBen
BigBen

Reputation: 50008

You can use the DATE and TIME functions to convert your text to date/time format.

=DATE(2018,MID(A2,4,2),LEFT(A2,2))+TIME(MID(A2,7,2),RIGHT(A2,2),0)

enter image description here

Using Filters:

enter image description here

Upvotes: 1

Related Questions