Convert dd/mm/yyyy to mm/dd/yyyy in Excel (with Images)
What is it?
By default Excel Date format is mm/dd/yyyy. There is a bigger challenge due to this default format!
What if you save a date in dd/mm/yyyy format 1/7/2014 (1st July 2014) but Excel will read it as January, 7, 2014 (1/7/2014).
The first option that comes to mind would be Right click > Format Cells > Date and select the desired date format, but that will not work here. Because Format Cells option will only change the date format Type and it will not convert the date format, so the best way to covert date format in excel is to use the below mentioned excel formula.
Eg: January, 7, 2014 (1/7/2014) to July, 1, 2014 (7/1/2014)
Why is it?
This Excel formula is very helpful when you have a huge data in dd/mm/yyyy format which was supposed to be in mm/dd/yyyy format.
As mentioned earlier fortunately or unfortunately the default option in Excel reads mm/dd/yyyy so the July 1st Excel reads as January 7th.
Since the data is huge you cannot change it one by one, In such cases you can use the below formula!
How to convert dd/mm/yyyy to mm/dd/yyyy in excel?
If you have the Date in Cell B1 then copy paste the below formula in Cell C1 and change the Cell C1 format to ‘Date’. That’s it!!!
Lazy to read? See the YouTube video on how to convert dd/mm/yyyy to mm/dd/yyyy in excel:
Let me know how helpful was this formula or if you know any other better ways to convert the date format in excel from dd/mm/yyyy to mm/dd/yyyy.