Google Sheets Date Format: Change and Customize Dates

Google Sheets dates are stored as numeric values and displayed using a date format. To change how an existing date looks, select the cell or range and choose Format > Number > Date; for a different pattern, choose Format > Number > Custom date and time. The display format does not, by itself, change the underlying date.

What a date format means in Google Sheets

A date format controls how a date value appears in a cell. The same underlying date might display as 3/4/2026, Mar 4, 2026, or Wednesday, March 4, 2026. These can all represent the same calendar day. Formatting changes the presentation, not the day represented by the value.

Sheets handles dates as numbers, with each whole-number step representing a day; time can be represented as a fractional part of a day. This is why dates can be sorted chronologically and used in calculations when Sheets recognizes them as date values. It also explains a common surprise: applying a date format to an ordinary number can make the number appear to be a date, even though that may not be what you intended.

Formatting is different from converting a date to text. A formatted date remains usable in date calculations. Text that merely looks like a date may not sort, filter, or calculate as expected. If you need a value to remain a real date, choose a date number format rather than building a text string.

Change the date format of existing cells

In Google Sheets in a web browser, select one or more cells, then open Format > Number. Choose Date for a standard date display, or choose another suitable option such as Date time if the cells include times. Sheets applies the selected format to the chosen range. You can also use the number-format controls in the toolbar when available, but the Format menu makes the options explicit.

If the standard Date option is not the presentation you want, use Format > Number > Custom date and time. In the dialog, choose or edit the date and time components, then apply the pattern. The available display depends on the locale and on which components you include. For example, a date-only pattern will not show an existing time component, even if the underlying value contains one.

Use a full year, such as 2026, when readers need to distinguish years clearly.
Use a month name, such as Mar or March, when a numeric day/month order could be ambiguous.
Apply the format to the whole relevant column or range if you want new entries to follow a consistent display.

Build a custom date pattern

Custom date and time formats let you choose which parts of a value appear and how they are written. Common pattern components include d for the day, m for the month, and y for the year. Repeating a component or using a longer form changes its display: a single day symbol can show a short day number, while a longer form can show the weekday name. The custom-format dialog previews the result, so check that preview before applying a pattern to a large range.

4 Mar 2026 is a compact, readable pattern for reports.
Wednesday, March 4, 2026 includes the weekday and spells out the month.
2026-03-04 puts the year first and uses leading zeroes, which is often easier to scan in data tables.

Use month names or a year-first pattern when a numeric format could be read two ways. For example, 04/03/2026 can mean April 3 or 4 March depending on the date convention in use. A display pattern can make the intended order clearer, but it cannot repair a date that was interpreted as the wrong day when it was entered or imported. Check the underlying value as well as its appearance.

Locale affects date entry and display

A spreadsheet’s locale influences default number and date conventions, including whether month or day comes first in familiar numeric displays. It can also affect how Sheets interprets date-like text that you type or paste. Consequently, the same string, such as 03/04/2026, may be read differently in spreadsheets configured for different locales. Do not assume that a displayed numeric order is universal.

To review the spreadsheet’s regional settings, open File > Settings and check the General settings for Locale and Time zone. Changing the locale can affect date, number, and currency conventions across the spreadsheet, so review existing data after a change. It is not merely a cosmetic setting if date-like text needs to be interpreted.

When sharing a sheet internationally, consider using an unambiguous display such as a spelled-out month or a year-first date. Also tell collaborators what locale the sheet uses if they will enter dates. A clear format helps people read values, while a consistent locale helps Sheets interpret new entries.

Enter dates reliably and use date formulas

For a date typed directly into a cell, use a form Sheets recognizes under that spreadsheet’s locale, and confirm that the result behaves like a date. If an entry remains left-aligned as text or does not respond to date formatting, it may not have been parsed as a date value. When precision matters, a formula can construct a date from separate year, month, and day numbers.

With no source cells needed, enter this in a blank cell: =DATE(2026,3,4). It returns the date March 4, 2026; the cell’s chosen number format determines how that date is displayed. The DATE function is useful in templates because its arguments explicitly identify the year, month, and day rather than relying on an ambiguous slash-separated entry.

With a valid date in A2, enter this in B2 to calculate the date one week later: =A2+7. If A2 contains March 4, 2026, B2 represents March 11, 2026. Format B2 as a date if it displays as a number. Adding seven changes the date value; applying a date format only changes how the result looks.

With a valid date in A2, enter this in B2 when you specifically need a text label: =TEXT(A2,"dddd, mmmm d, yyyy"). If A2 is March 4, 2026, the result is Wednesday, March 4, 2026. Unlike a date-formatted cell, the TEXT result is text, so it is generally not the right choice for a column that must remain available for date arithmetic or chronological sorting.

Why dates sometimes appear as numbers or text

If a date suddenly appears as a large number, the cell may have been set to a number format rather than a date format. Select it and apply Format > Number > Date. Because Sheets stores dates numerically, a number display can reveal the underlying serial value rather than indicating that the date has disappeared. Conversely, if an ordinary number becomes a date after formatting, change it back to an appropriate number format.

If formatting has no effect, the cell may contain text instead of a date value. Imported files, copied data, leading apostrophes, spaces, and locale mismatches can all leave date-looking entries as text. Try checking a small sample, removing unintended spaces, and confirming the spreadsheet locale before changing a whole column. If the data comes from another system, inspect its export settings or import options too; changing the display format cannot convert every text string automatically.

Also check whether a formula is returning text, or whether the source contains a date with an unexpected order. A value that looks correct in one locale can represent a different day in another. Before sorting or calculating, verify a few known dates against their original source rather than assuming that a new format has fixed the data.

Dates in sorting, filtering, and shared sheets

Real date values sort in calendar order when sorted as dates. Text dates may sort alphabetically or in an order that looks inconsistent, especially when month and day components have different lengths. A year-first pattern with leading zeroes can make text easier for people to scan, but it does not turn text into a date. Confirm that the cells contain date values when the column must support date filters, calculations, or chronological sorting.

In a shared sheet, decide on a display pattern that makes sense for the people reading it, then apply it consistently to the relevant range. Do not assume that changing the display format changes how another collaborator’s entry will be interpreted: interpretation is tied to the spreadsheet’s settings and the way the value is entered. Protecting data quality may require clear instructions for contributors or validation rules, not just a prettier date display.

Google Sheets date formats compared with Excel

Google Sheets and Excel both use number formats to display date values, and many familiar patterns look similar. However, their menus and format dialogs are not identical. In Sheets, use Format > Number and the custom date and time option; Excel has its own number-format controls. Do not rely on an Excel-specific menu path when following instructions in Sheets.

When moving a spreadsheet between programs, check the displayed dates and a few underlying values, especially if the workbook includes text dates or dates entered under different regional settings. A format may transfer differently from the data’s interpretation, and a pattern that looks familiar does not prove that every value was imported as a true date. For shared or converted files, test sorting and a simple date calculation on representative rows.

Frequently Asked Questions

How do I change the date format in Google Sheets?
Select the cells, then choose Format > Number > Date. For a particular pattern, choose Format > Number > Custom date and time, select the components you want, and apply the format.

How do I make Google Sheets show dates as YYYY-MM-DD?
Select the date cells and open Format > Number > Custom date and time. Set the pattern to a year-first display with a four-digit year and two-digit month and day, then verify the preview before applying it.

Why is Google Sheets showing a date as a number?
The cell may be using a number format. Apply Format > Number > Date. If the value still does not behave like a date, check whether it is text or whether the original entry was interpreted incorrectly.

Why does Google Sheets change the date I type?
Sheets interprets date-like entries according to the spreadsheet’s regional settings, and numeric date orders differ between locales. Check File > Settings for the locale, and use an unambiguous month name or the DATE function when the intended day must be clear.

Does changing a date format change the actual date?
No. Applying a number format changes the display of a date value, not the underlying day. Changing a value with a formula or editing the entry can change the date; formatting alone does not.

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.