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

Launching soon...

E-book price at Amazon will be $14.99 

A Practical Guide To Online Business
Congratulations!
You Made It,
Don't Close!

Enter your chance to win our Premium Membership License for FREE! ( Normal Price $199/Year)

Thank you for your visit!

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

Premium Membership Giveaway - Popup
small_c_popup.png

Let's have a chat

Fill out the form below to consult with us

*Please check your Inbox or Junk Folder for the Confirmation Email. You must confirm your Company email address before we could revert.

Share to...