Forum Discussion
Excel Formula: What am I doing wrong?
Hi Brains Trust, I am trying to convert an 8-digit reverse date text string in to dd/mm/yyyy date format. What am I doing wrong? Column A is 'Text', Column B is 'Date' set to dd/mm/yyyy. I just need to reverse the text-formatted dates, to put them in day/month/year date numerical format.
The left 4 digits are the same on both A rows, yet they are transposing to completely different years; LEFT(A2,4) should give me the first four digits, from the left, in cell A2. Clearly it's not. I've read and reread articles on using this formula, and can't work out what I'm doing wrong?
Many thanks for your input,
David
2 Replies
First convert text to any date format, then convert it to a real date value. Finally apply your desired date format to display it.
=--TEXT(A2,"0000\/00\/00")=DATE(MID(A2,1,4),MID(A2,5,2),MID(A2,7,2))Does this return the intended result?
