Forum Discussion
HOW DO I CONVERT DATES FROM TWO DIFFERENT FORMATS ?
I receive dates in one of two formats: YYYY-MM-DD or YYYY-DD-MM I would like to have a formula to convert either of these scenarios and convert into the date format MM/DD/YYYY One p...
Hello,
what do you mean with "dates come in text format and not in a date format"? Can you give an example?
How is the data arriving on your computer? Is it a CSV file?
If the date format of the source file is not the same as the date format used by your computer, use the import wizard to import the file instead of opening it directly in Excel. The import wizard has a step where you can convert data formats from one form to another.
For more details, please tell us more about your scenario.