Google Sheets English Date Format: Set Dates Correctly

To display dates in English in Google Sheets, select the date cells and choose Format > Number > Date, or use Format > Number > Custom date and time to choose a specific style. To set English as the spreadsheet’s regional default, open File > Settings and select an English locale; the locale also affects how Sheets interprets newly entered dates.

What “English date format” means in Sheets

There is no single date style used by every English-speaking country. In the United States, a common order is month, day, year: 3/8/2026 means March 8, 2026. In the United Kingdom and many other places, day, month, year is common: 3/8/2026 means 3 August 2026. A reader who does not know the convention can easily misunderstand a short numeric date.

In Google Sheets, two related settings matter. A cell’s number format controls how a date value looks, while the spreadsheet’s locale supplies regional defaults and influences how entries are interpreted. You can therefore display a date in a chosen English style without changing the spreadsheet’s locale, or change the locale to make its defaults match your audience. If you want both clear display and predictable entry, consider both settings.

The language of Google Sheets’ menus is a separate matter. Changing your browser or Google Account language does not necessarily change the date conventions of a particular spreadsheet. The spreadsheet locale is the key setting for regional date behavior.

Set the spreadsheet locale to English

To change the regional defaults for the whole spreadsheet, use these steps in Google Sheets in a web browser:

Open the spreadsheet and choose File > Settings.
On the General tab, open the Locale menu and choose the English-speaking region you need, such as United States, United Kingdom, Canada, or Australia.
Check the time zone as well if the sheet contains times or date-and-time values.
Choose Save settings. Sheets may reload the spreadsheet for the new settings to take effect.

Choose a region, not merely the word English, when the distinction matters. English (United States) and English (United Kingdom), for example, have different customary date orders. Locale is a spreadsheet-level setting, so collaborators using the same file work with the same regional defaults. It can also affect number and currency conventions, such as decimal separators and the default currency; it is not simply a cosmetic date-language switch.

Choose a display format for selected cells

A locale does not force every date cell to use one exact appearance. For a standard date, select the cells, then choose Format > Number > Date. Sheets applies a date format appropriate to the spreadsheet’s regional settings. For a particular order or a more readable month name, use Format > Number > Custom date and time. The dialog offers date and time components that you can arrange, then apply to the selection.

Common styles include:

3/8/2026 — compact, but ambiguous across regions.
08/03/2026 — day/month/year, still easy to misread if the audience expects month/day/year.
8 Mar 2026 — concise and clearer because the month is written as a name.
8 March 2026 — more explicit and readable in reports.
2026-03-08 — year-month-day, useful in technical or international contexts when the order is documented.

In the custom date-and-time dialog, components such as day, month, and year can be combined into a display pattern. For example, a pattern equivalent to day, abbreviated month, and four-digit year produces a style like 8 Mar 2026. The exact preview reflects the spreadsheet locale. Apply the format to the entire relevant column if new rows will be added, and verify that the format is also applied to any rows inserted later.

Formatting changes appearance, not the date itself

A genuine date in Sheets is stored as a date value, rather than as the words you see on screen. The cell’s number format tells Sheets how to display that value. Changing a cell from a US-looking format to a UK-looking format normally changes its appearance, not the underlying calendar day. This is why the same date can be shown as 3/8/2026, 8/3/2026, or 8 Mar 2026 depending on formatting and locale.

This distinction also explains a frequent problem: applying a date format does not necessarily fix a date stored as text. If a cell contains the literal characters “31/12/2025” and Sheets has treated them as text, choosing a date format may leave the characters unchanged. Text does not behave like a date value in date arithmetic, sorting, or date-based filters. A left-aligned appearance can be a clue that an entry is text, though alignment alone is not a definitive test because users can change alignment manually.

To check, select a suspicious cell and look at the formula bar and how the value behaves. Try a date format, or use a simple date calculation in a separate cell. If the value does not respond as a date should, clean or convert the source rather than repeatedly changing its display format.

Prevent ambiguous dates when entering or importing data

When people type dates directly, their expectations may not match the spreadsheet locale. For instance, 04/05/2026 could mean April 5 or 4 May. If the month and day are both 12 or lower, Sheets cannot infer the writer’s intended convention from the digits alone. Agree on one entry style with collaborators, and use a month name or a four-digit year when that helps remove doubt.

For CSV files and copied data, inspect the results after import. Sheets may interpret recognizable date strings according to the spreadsheet locale, while some source values may remain text. A column can even end up with a mixture of real dates and text if the source contains inconsistent patterns, spaces, or labels. Before sorting or calculating, check several rows, including dates where the day is greater than 12; those can reveal a day/month mismatch quickly.

Keep a consistent source pattern throughout each date column.
Use a four-digit year to avoid uncertainty about two-digit years.
For shared reports, consider a month name or a documented year-month-day order.
After importing, apply a date format and check whether the values sort in chronological order.

Changing the locale can help with future entry and regional defaults, but it is not a universal repair tool for a column of text. Make a copy before doing a large cleanup, particularly if the original imported values may be needed for reference.

Convert fixed-pattern date text with a formula

If a cell contains text in a consistent pattern, a formula can assemble a real date from its parts. For example, suppose A2 contains the literal text 31/12/2025 in day/month/year order. In another cell, enter =DATE(VALUE(RIGHT(A2,4)),VALUE(MID(A2,4,2)),VALUE(LEFT(A2,2))). It returns the date December 31, 2025, which you can then display using Format > Number > Date or a custom format.

This formula assumes every source value has exactly two digits for the day, two for the month, and four for the year, with slashes in the same positions. It is not suitable for variable-width entries such as 1/2/2025, dates with month names, or values containing extra spaces without adjustment. It also does not decide what an ambiguous string was meant to mean; the assumed order must match the source. For a large or irregular dataset, standardize the input first or use a controlled import and review the converted results.

Dates, times, and time zones

A date-and-time value combines a calendar date with a time, so changing the display pattern can show only the date, only the time, or both. In Sheets, time-zone settings matter when values or formulas represent the current time, and collaborators may need to agree on the relevant zone for a schedule or timestamp. Check File > Settings if displayed times seem shifted. A date-only value is usually less sensitive to time-zone differences, but imported timestamps and formulas that use the current date or time deserve extra care.

Also distinguish a date from a timestamp. If a cell includes a time but its format shows only the date, the time may still be part of the stored value and can affect sorting or comparisons. Conversely, a format that shows hours and minutes does not create time information if the underlying value contains only a date. Choose a display that communicates the precision your data actually has.

When to use English names or an international style

For a report meant for English readers, “8 Mar 2026” is often a practical compromise: the month is clear, the year is explicit, and the format is compact. A fully written month, as in “8 March 2026,” can be easier for a general audience. Numeric formats are shorter and convenient for data entry, but they need a known convention.

For technical records, filenames, or data exchanged between systems, year-month-day can be useful because the largest unit comes first and values can sort lexically when consistently padded. Do not assume that a visually ISO-like string is automatically stored as a true date or will be parsed identically everywhere. Keep the source data consistent, and test imports and exports with the systems that will use the file.

Unlike a plain text editor, a spreadsheet separates a date’s stored value from its display format. Excel also uses date values and number formats, but menu paths and locale behavior are not identical. These steps and menu names refer to Google Sheets in a web browser; in Excel, use its own number-format controls rather than expecting Google Sheets menus.

Frequently Asked Questions

How do I change Google Sheets from US dates to UK dates?
Choose File > Settings, select United Kingdom in the Locale menu, and save. Then review existing date columns: genuine date values may display differently, but text entries may need separate conversion.

How do I make dates show the month name?
Select the cells and choose Format > Number > Custom date and time. Choose a pattern with an abbreviated or full month name, preview it, and apply it. For example, a result such as 8 Mar 2026 is clearer than 08/03/2026 across regions.

Why does changing the date format not change my cell?
The entry may be text rather than a date value, or it may contain inconsistent characters or spaces. A number format changes the appearance of date values; it does not automatically parse every text string into a date.

Does changing the locale change existing dates?
It can change how stored date values are displayed and how future entries are interpreted, but it does not reliably convert text strings into dates or resolve what an ambiguous entry originally meant. Check important columns after changing the setting.

What date format is least confusing internationally?
A month name, such as 8 Mar 2026, avoids the common day/month versus month/day ambiguity. A consistently padded year-month-day format can suit technical data, but document the convention for anyone entering or reading the values.

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.