Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in


How to quickly convert Euro date format to US date in Excel?

In US, we enter date in Excel as the date format mm/dd/yyyy in generally, but in Euro, the date format usually is dd/mm/yyyy. If you are working in an international coordinate company, you may suffer with the problem that convert Euro date format to US date format. In this article, I will tell you the methods on quickly converting Euro date to US date format.

Convert Euro date to US date with formula

Convert multiple nonstandard date to standard date with Kutools for Excel good idea3

Convert to Date

In some times, you can have multiple nonstandard dates in your worksheet, and to convert all of them to the standard date mm/dd/yyyy maybe troublesome for you. Here Kutools for Excel's Conver to Date can quickly convert dates to standard date as mm/dd/yyyy format.
doc convert date

arrow blue right bubble Convert Euro date to US date with formula

Here is a formula can convert Euro date format to US date format.

Select a cell which you will place the US date, for instance, C10, enter this formula =DATE(VALUE(RIGHT(A2,4)), VALUE(MID(A2,4,2)), VALUE(LEFT(A2,2))), drag fill handle down to the cells needed to apply this formula. See screenshot:
doc euro date to us 1

Note: This formula can only convert Euro dates which are stored as text string to US dates.

doc attention 1  Kutools for Excel's Auto Text, collect all formulas to a group as auto text, you can insert them anytime as you want whithout remembering! Free Download Now!

arrow blue right bubble Convert multiple nonstandard date to standard date with Kutools for Excel

If you usually import Excel sheets from other users or other locations, which maybe includes multiple non-standard date formats, how can you quickly convert these dates to the standard date format when you work in Excel?

If you have Kutools for Excel – a handy and powerful tool, its Convert to Date utility can help you to quickly convert nonstandard dates to standard date includes converting Euro date to standard date.

Kutools for Excel, with more than 120 handy Excel functions, enhance your working efficiency and save your working time.

After free installing Kutools for Excel, please do as below:

1. Select the dates you want to convert, and click Kutools > Content > Convert to Date. See screenshot:
doc euro date to us 2

2. And then the Convert to Date dialog pops out to automatically convert the dates to standard dates. See screenshot:
doc euro date to us 3doc euro date to us 4

doc download 1

Apply Date formatting (change date to multiple date formatting as you need)

doc apply date formatting

Recommended Productivity Tools for Excel

Kutools for Excel Helps You Always Finish Work Ahead of Time, and Stand Out From Crowd

  • More than 300 powerful advanced features, designed for 1500 work scenarios, increasing productivity by 70%, give you more time to take care of family and enjoy life.
  • No longer need memorizing formulas and VBA codes, give your brain a rest from now on.
  • Become an Excel expert in 3 minutes, Complicated and repeated operations can be done in seconds, 
  • Reduce thousands of keyboard & mouse operations every day, say goodbye to occupational diseases now.
  • 110,000 highly effective people and 300+ world-renowned companies' choice.
  • 60-day full features free trial. 60-day money back guarantees. 2 years of free upgrade and support.

Brings Tabbed Browsing and Editing to Microsoft Office, Far More Powerful Than The Browser's Tabs

  • Office Tab is designed for Word, Excel, PowerPoint and Other Office Applications: Publisher, Access, Visio and Project.
  • Open and create multiple documents in new tabs of the same window, rather than in new windows.
  • Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.

Be the first to comment.