Excel Formula to convert mm/dd/yyyy to dd/mm/yyyy

Share on facebook
Share on twitter
Share on linkedin

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)))))



dd/mm/yyyy

Anson Antony

Anson Antony

Anson is a contributing author and founder at ASKEYGEEK.com. Learning anything new has always been his passion, ASKEYGEEK.com is an outcome of his passion for technology and business. He has got a decade of versatile experience in Business Process Outsourcing, Finance & Accounting, Information Technology, Operational Excellence & Business Intelligence. During the tenure, he had worked for organizations like Genpact, Hewlett Packard, M*Modal and Capgemini in various roles and responsibilities. Outside business and technology, he is a movie buff who spends hours together watching and learning Cinema and a Film Maker too!

One Response

Leave a Reply

Your email address will not be published. Required fields are marked *

small_c_popup.png

Let's have a chat

Fill out the form below to consult with us