Excel Formula to convert dd/mm/yyyy to mm/dd/yyyy (with Images)
dd/mm/yyyy to mm/dd/yyyy Cell format using Excel Formula
What is it?
This excel formula will help you to convert Date Format which is in dd/mm/yyyy to mm/dd/yyyy
Eg: January, 7, 2014 (1/7/2014) to July, 1, 2014 (7/1/2014)
Why is it?
This is very important when you have received a huge data in dd/mm/yyyy format which was supposed to be received in mm/dd/yyyy format and fortunately or unfortunately the default option in Excel reads mm/dd/yyyy so your July 1st Excel read as January 7th. Because there are a lot of data you cannot change it one by one, In such cases you can use the below formula!
If you have the Date in Cell B1 then copy paste the below excel formula in Cell C1 and change the Cell C1 format to ‘Date’. That’s it!!!