I have a column of dates in the following format
ddd mmm dd hh m:s "EST" yyyy. In another cell in another sheet, I wish to have the dates in the format
dd/m/y. How can I do this?
I already tried the
DATEVALUE function. Seeing as the positions are fixed, I started using the
MID functions to extract components to put into the DATE function. Unfortunately, I don't know of a way of converting the three letter string to a month without writing a huge if block.
UPDATE: I managed to convert the string using MONTH(1&THREE_LETTER_DATE). I am still curious if there is a better solution though