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!
How to:
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!!!
=IF(B1=””,””,IF(DAY(B1)>12,DAY(B1)&”/”&MONTH(B1)&”/”&YEAR(B1),VALUE(DATE(YEAR(B1),
DAY(B1),MONTH(B1)))))
