Forum Discussion
DavidB80
Feb 19, 2025Copper Contributor
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 ne...
OliverScheurich
Feb 20, 2025Gold Contributor
=DATE(MID(A2,1,4),MID(A2,5,2),MID(A2,7,2))Does this return the intended result?