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

dd-mm-yyyy to mm-dd-yyyy
Table of Contents

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 www.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!

Leave a Reply

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

Congratulations!
You Made It,
Don't Close!
Enter your chance to win 100,000 UberTTS Character Credits
Thank you for your visit!

This popup won’t show up to you again!!!

UberTTS 100K Easter Egg
Share to...