Google Sheets European Date Format: Set It Correctly

To use a European-style date in Google Sheets, set the spreadsheet’s region under File > Settings > General > Locale, then select the date cells and choose Format > Number > Custom date and time to display them as dd/mm/yyyy, for example. A locale controls how Sheets interprets and formats dates across the spreadsheet; a cell format controls how a date value looks.

What European date format means in Sheets

There is no single date format used throughout Europe. Day-month-year is common in many European countries, but punctuation and preferred year styles vary. A UK-style date might appear as 03/04/2026, while a German-style date might appear as 03.04.2026. Both examples mean 3 April 2026. The ISO-style format 2026-04-03 is another useful option, especially in records shared internationally, because the year-month-day order avoids the familiar day-versus-month ambiguity.

Google Sheets separates a date’s underlying value from its display. A recognized date is stored as a date value, which Sheets can use in sorting, calculations, charts, and date-based functions. The format changes how that value is shown, not the day it represents. For example, the same date value might display as 4/3/2026 in a US-formatted sheet and 03/04/2026 in a day-first format.

This distinction matters because a cell that merely contains the text 03/04/2026 is not necessarily a usable date. If Sheets interpreted it as text, changing the cell’s number format will not turn it into a date. Locale settings and the way data is entered both influence whether a value is recognized correctly.

Locale versus cell formatting

Locale and number formatting solve related but different problems. The spreadsheet locale is a regional setting for the whole file. It influences default date, number, and currency conventions, and it can affect how entered or imported values are interpreted. Choosing a country such as the United Kingdom or Germany is often the simplest way to make a sheet behave in line with the conventions you expect.

Cell formatting applies to selected cells. It lets you show dates in a particular order without changing the spreadsheet’s regional defaults. For instance, you can retain a US locale for other collaborators or number conventions but display a date column as day/month/year. Conversely, changing the locale does not guarantee that every existing cell will use exactly the custom appearance you want.

Choose a locale when the spreadsheet as a whole should use a region’s conventions.
Choose a cell format when a particular column or range needs a specific visual style.
Use both when you want regional defaults and a consistent, explicit date display.

Because the locale is a spreadsheet-wide setting, check with collaborators before changing it in a shared file. A setting that helps one person can alter how dates, decimal values, and currencies appear to everyone using that spreadsheet.

Set the spreadsheet to a European locale

In Google Sheets in a web browser, open the spreadsheet and follow these steps. The menu labels below assume the interface is in English; translated interfaces may use translated labels.

Choose File > Settings.
Under General, open the Locale list.
Select the country whose conventions you want, such as the United Kingdom, Ireland, France, or Germany. Do not assume that one country setting represents all of Europe.
Select Save settings. Sheets may reload the spreadsheet to apply the change.
Review a few date, number, and currency cells, especially if other people use the file.

The locale is not the same thing as the language of the menus. It is possible to use Sheets in one interface language while the spreadsheet uses another country’s regional settings. This can be useful for a multilingual team, but it also makes it worth documenting the intended date convention in a shared template.

Format a date column as day, month, year

If the dates are already recognized as date values, you can set their display without changing each date individually. Select the cells or entire column, then choose Format > Number > Custom date and time. In the custom-format dialog, choose or arrange the day, month, and year components in that order. A pattern such as dd/mm/yyyy displays a two-digit day, a two-digit month, and a four-digit year. Apply the format when it looks right in the preview.

For example, with a real date value representing 3 April 2026, that pattern displays 03/04/2026. A pattern with a four-digit year is generally clearer than a two-digit year in schedules, invoices, and long-lived records. If you prefer separators such as dots or hyphens, select a suitable custom pattern in the dialog. The separators affect appearance, not the date value itself.

For a quick standard format, select the range and use Format > Number > Date. The exact appearance of this standard option can depend on the spreadsheet’s locale. Use the custom date-and-time dialog when you need a specific order or separator that should remain consistent.

Enter dates without creating ambiguity

Numeric dates such as 04/05/2026 are ambiguous when a sheet’s locale is unknown: they can mean 4 May or April 5. If a date is important, confirm the spreadsheet’s locale before entering a series, or use a method that makes the year, month, and day explicit. A month name can also help people reading a sheet, as in 4 May 2026, though the resulting entry should still be checked to make sure Sheets recognized it as a date.

For a formula-based example, with the formula entered in cell A1 in a sheet that uses comma argument separators, enter =DATE(2026,4,3). It creates the date value for 3 April 2026; applying dd/mm/yyyy displays it as 03/04/2026. Some spreadsheet locales use semicolons rather than commas between formula arguments, so follow the separator accepted by the formula editor in your sheet.

To check whether a value is behaving like a date, try changing its format to a different date style or sort a small test range from oldest to newest. Real dates should sort in chronological order. Text dates may sort alphabetically or stay in an unexpected position. This is a useful check before using the column in formulas or reports.

Fix dates that show the wrong day or month

If a date displays in the wrong order, first distinguish a display problem from an interpretation problem. If the underlying date is correct but appears month-first, apply the desired custom format. If Sheets interpreted an ambiguous entry as the wrong day, changing its format only changes how that incorrect value is displayed; it does not swap the day and month.

Check the locale: Open File > Settings > General and confirm the country setting matches the intended input convention.
Test an unambiguous date: Use a date with a written month or a year-month-day pattern, then check that Sheets treats it as a date.
Look for text: If changing the number format has no effect, the cells may contain text rather than date values.
Correct the source carefully: For a small range, re-enter dates after confirming the locale. For a large import, make a copy first and verify the results before replacing original data.

Do not fix a misread date by blindly replacing every slash or swapping every pair of numbers. A column can contain both ambiguous and unambiguous entries, and an automatic replacement can create new errors. Compare a few known dates against the original source before relying on the corrected column.

Imports, sharing, and time zones

CSV files are a common source of date problems because they may contain dates without an explicit description of whether the first number is the day or month. Before importing a CSV into a shared spreadsheet, decide which locale matches the source data and inspect the imported dates. Google Sheets’ import options can convert text to numbers, dates, and formulas; that conversion is useful when appropriate, but it can also interpret ambiguous text according to regional conventions. Keep a copy of the source file and check representative rows after import.

When sharing a spreadsheet across countries, agree on one input convention and use a visible, consistent display format. A header such as Date (DD/MM/YYYY) helps, but it does not itself change how Sheets reads typed values. If readers need to exchange data with other software, an ISO-style year-month-day display can reduce confusion. Ask collaborators to avoid entering ambiguous numeric dates without knowing the spreadsheet’s locale.

Date and time settings should not be confused with date order. The spreadsheet’s time zone is a separate setting and matters for values that include times, timestamps, or time-based calculations. Changing a date display from month-first to day-first is not a substitute for checking the time zone, and changing the time zone does not establish a European date format.

Frequently Asked Questions

How do I change Google Sheets from US to European date format?
Choose File > Settings > General > Locale, select the relevant country, and save. Then select the date cells and apply Format > Number > Custom date and time if you need a particular day-first display.

Is DD/MM/YYYY the standard European date format?
It is common in many European countries, but Europe does not have one universal format. Some countries use dots or other conventions, and YYYY-MM-DD is a clear international option. Pick the format that suits the source, readers, and purpose of the sheet.

Why does changing the format not fix my date?
The cell may contain text, or Sheets may already have interpreted an ambiguous entry as the wrong date. Formatting changes how a recognized date looks; it does not reliably convert text or correct an incorrectly interpreted day and month.

Can I use DD/MM/YYYY without changing the spreadsheet locale?
Yes. Select the date cells and use Format > Number > Custom date and time to apply a day-first pattern. Remember that this sets the display, not necessarily the rules used to interpret new dates typed into the sheet.

Why do collaborators see a different date format?
They may be viewing another spreadsheet or using a different format on their own cells, but a date’s number format is stored with the cells. In a shared file, check the spreadsheet locale and the format applied to the date range; agree on one explicit display pattern for consistency.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.