Forum Discussion
Convert DD/MM/YYYY HH:MM to MM/DD/YYYY HH:MM
I have a spreadsheet that I am working on and the dates that have been given on the sheet are in the European format (DD/MM/YYYY HH:MM), but I need these converted to the US format (MM/DD/YYYY HH:MM)...
I have attempted this as well, but it still isn't reading the dates properly. It will read some, so long as the day displayed is less than 12. However with this the information is confused and European format 13/01/2019 is not recognized and 12/01/2019 is recognized as December 1, 2019 when converted to US format.
=IF(ISNUMBER(SEARCH(“/”,A1)),DATE(RIGHT(A1,4)*1,LEFT(A1,2),MID(A1,4,2)),IF(A1=0,””,A1))
untested, should work :))
untested, should work :))