Convert text-formatted date to regular date

Good afternoon,

Does anyone know a formula that I can use to convert a text-formatted date? The date come across as general format with the following format: Jul 27 2017 09:43PM. I tried the valuedate formula but it does not seem to be working

Thanks,

Jorge

Do you want to retain the time information as well, or just the date?

If you only want the date then you can use this in B1, assuming the text string is in A1:

=DATEVALUE(LEFT(A1,11))

Format as a date in the style you prefer.

IF you want the time in C1, you can use this:

=--(LEFT(RIGHT(A1,7),5)&":00") + IF(RIGHT(A1,2)="PM",0.5,0)

Hope this helps.

Pete

It worked. Thank you!

If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post and mark this thread as SOLVED.

Also, since you are relatively new to the forum, you might like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete