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))
Enjoy.
No comments:
Post a Comment