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

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




About Anson

I’m Anson, having versatile experience in Business Process Outsourcing, Finance & Accounting, Information Technology, Operational Excellence & Business Intelligence. I'm currently working in a MNC in Bangalore, India. Learning anything new has always been my passions and if its related to Business and Technology then, I love it. This website/blog is an outcome of my passion towards it and I have been blogging since 2012. Outside business and technology I’m a movie freak who spends hours together watching and learning Cinema.

One Comment

  1. Pingback: dd/mm/yyyy to mm/dd/yyyy format in Excel (with ...

Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.