Excel Guides

Converting European Dates to US Dates in Excel

When working with international teams, it's not uncommon to have to convert dates from one format to another. For example, you may need to convert European dates (e.g., 10/3/2019) to the US date format (e.g., 3/10/2019).

There are a few different ways that you can convert dates in Excel:

  1. Using the TEXT Function

You can use the TEXT function to convert a date from one format to another. For example, the following formula will convert a European date (10/3/2019) into the US date format (3/10/2019):

=TEXT(A1,"mm/dd/yyyy")

Note: The "A1" in the formula above refers to the cell that contains the date that you want to convert.

  1. Using the DATEVALUE Function

You can also use the DATEVALUE function to convert a date from one format to another. For example, the following formula will convert a European date (10/3/2019) into the US date format (3/10/2019):

=DATEVALUE(A1)

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.