Convert text to dates in Excel
Rewrite dates written in mixed ways — 2024/4/1, 20240401, 04/01/2024 and Japanese era dates — in one format you choose. Your files are processed inside this browser and never uploaded.
Choose files
File 1
Choose several files to apply the same fixes to all of them
Fixes
Load a file to set this up.
See the outcome
The outcome appears here once you run it.