Forum Discussion
Help with Text to Date Formula
Hello, I have been using many different methods for attempting to convert text and date - but failing miserably! Essentially, the way I can download data provides dates that appear like this: ...
Depends on regional setting and defined long date format, for US ones could work
=DATEVALUE(SUBSTITUTE(A1,MID(A1,7,2),""))