06 May, 2020

American Dates

Honestly, you guys suck.  What on earth makes you think that this format is in any way useful?!?

October 10, 2012

It is a heinous crime against data.

Anyway, I have spent far to long trying to work out how to convert this to a proper date in excel.  Here is my resulting formula,  I am fairly sure no one will ever find this, but I have put it out there for all and sundry.

=DATE(RIGHT(E2,4),MONTH(1&LEFT(E2,3)),RIGHT(MID(E2,FIND(" ",E2),3),2))