Text Date to Date

[dantheram]

Hi all,

I have cells with the following date format "3 Aug, 2017 10:00AM"

Is there a simple way to split out the date?

Dan

 

[dantheram]

I see, you're using UK dates.

This should handle either Aug 3, or 3 Aug

=IFERROR(LEFT(A1,12)+0,DATE(MID(A1,8,5),MONTH(LEFT(A1,3)&1),MID(A1,5,LEN(A1)-18)))

Works perfectly, thanks

 

[Jonmo1]

You're welcome.