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

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:

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

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.

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:

2. And then the Convert to Date dialog pops out to automatically convert the dates to standard dates. See screenshot: