How to Write Dates in Google Sheets

To write a date in Google Sheets, select a cell, enter a date in a format your spreadsheet’s locale recognizes, and press Enter. To control how it appears, select the cell and choose Format > Number > Date or Format > Number > Custom date and time. These steps are for Google Sheets in a web browser.

What You’ll Need

A Google account and a spreadsheet open in Google Sheets.
The date or date range you want to enter, plus a preferred display style such as 3 Nov 2026 or 11/03/2026.
If dates are being shared with people in other regions, an agreed date convention or an appropriate spreadsheet locale.

Step-by-Step

Select the destination cell or range. Click a cell to enter one date, or drag across a range if you want to set its display format before entering several dates. To apply the same format to a whole column, click its letter at the top. Formatting the range first can help keep new entries consistent, although Sheets may still interpret typed input according to the spreadsheet’s locale.
Enter an unambiguous date. Type a date and press Enter. For example, a date such as 3 Nov 2026 makes the month clear to a reader and avoids the ambiguity of 03/11/2026, which can mean March 11 or November 3 depending on regional conventions. If you use a numeric style, check whether the spreadsheet expects month/day/year or day/month/year. Use four digits for the year to reduce confusion between centuries.
Use the date shortcut for today, if appropriate. In a selected cell, press Ctrl+; on Windows or ⌘+; on Mac to insert the current date as a fixed value. It will not roll forward on later days. The shortcut depends on your keyboard layout and browser; if it does not work, type the date or check Help > Keyboard shortcuts in Sheets. To insert the current time, the shortcut is Ctrl+Shift+; on Windows or ⌘+Shift+; on Mac. A date-and-time entry can be formatted afterward to show only the part you need.
Apply the standard date format. Select the date cell or cells, then choose Format > Number > Date. Sheets displays the value using a date style associated with the spreadsheet’s locale. If you see a number instead of a date, this step often changes the display to a readable date without changing the underlying value.
Choose a specific date style when needed. For more control, select Format > Number > Custom date and time. Choose a suggested style or build one by selecting the date components and their order. For instance, a style with a day number, abbreviated month, and four-digit year can display as 3 Nov 2026. A two-digit day and month with a four-digit year can display as 03/11/2026, but use that numeric version only when readers know which order it represents. Apply the selection to finish.
Check the spreadsheet locale if dates are being misread. Choose File > Settings and look under General for Locale. The locale affects default date, number, and currency conventions, as well as how entries are interpreted. Pick the locale that matches the data’s intended convention, then save the settings. Be aware that changing it can affect the appearance and interpretation of existing values, so review the sheet afterward. For a shared spreadsheet, tell collaborators which date order to use rather than assuming everyone’s local settings are the same.
Enter a date with DATE when you need a dependable formula. This is useful when a date is assembled from separate year, month, and day values, or when an ambiguous typed date must be avoided. With no other cell references required, enter =DATE(2026,11,3) in a cell; it returns the date November 3, 2026, displayed according to that cell’s date format. The argument order is year, month, day. Format the result using the steps above if it appears as a serial number or in an unwanted style. You can also reference cells containing the year, month, and day instead of typing those numbers directly.

Common Mistakes

Assuming every numeric date has the same meaning. The entry 04/05/2026 is ambiguous across regions. Before filling a column, confirm the convention with the people who will use the sheet. If the data comes from different sources, standardize it carefully and verify a few known dates instead of assuming that changing the display format corrected the underlying values.

Confusing display format with the stored value. A date format changes how a valid date is shown; it does not necessarily convert text into a date. Conversely, choosing a different display pattern generally does not change the date itself. If formatting has no effect, investigate whether the value was recognized as a date in the first place.

Entering dates as plain text unintentionally. A leading apostrophe, such as '3 Nov 2026, tells Sheets to treat the entry as text. That can be useful for labels or preserving a literal string, but text dates may not sort, calculate, or work in date-based filters like actual dates. Do not add an apostrophe unless you specifically want text.

Using two-digit years or relying on auto-fill without checking. A short year can be interpreted differently than intended, and dragging a cell’s fill handle may continue a series rather than copy one identical date. Use four-digit years and inspect the filled values, especially across month-end or year-end.

Tips

Use a written month name when humans will type dates by hand, and use a consistent numeric style when dates are part of a structured dataset. For tables shared across countries, 2026-11-03 is a useful year-month-day convention for communicating the intended order, but confirm that the spreadsheet has parsed it as a date rather than assuming the visible text proves that it is a date value.

Apply a date format to the entire date column before pasting or entering a large batch. After pasting, check a few cells with different days and months, including one where the day is greater than 12; that helps reveal whether month and day have been reversed. Keep headings explicit—for example, “Due date (day/month/year)”—if readers might otherwise interpret the values differently.

For a fixed record of when something happened, use a manually entered date or the date shortcut. A formula such as =TODAY() is different: it calculates the current date and can update as the spreadsheet recalculates on a later day. If you use it, make sure a changing value is what you want. To preserve a date produced by a formula, copy the cell and use Edit > Paste special > Values only.

When presenting dates alongside times, choose a custom date-and-time format that includes both components. A date-only format can hide the time portion even when the stored value includes it. Keep the original data intact before converting a large imported column, and test the conversion on a copy or a few sample cells first.

Troubleshooting

The cell shows a number such as 46329. Sheets stores dates as numeric values internally, so a plain number format can expose the underlying serial number. Select the cell and choose Format > Number > Date, or choose a custom date and time format. If it still shows the number, check that you selected the cell containing the value and not a neighboring cell.

The date is displayed in the wrong order. The spreadsheet locale or the chosen custom format may not match your intended convention. Check File > Settings > General > Locale, then inspect the custom date format. Changing the display pattern can clarify a date, but if the original ambiguous entry was interpreted as the wrong day and month, changing the pattern alone will not repair it. Compare it with the source and correct the underlying value.

Formatting does not change anything, or sorting puts dates in the wrong place. The cells may contain text rather than date values. Click a cell and inspect the formula bar and alignment, but do not rely on alignment alone as proof. Try entering one known date in a blank cell and formatting it as a date. If that works while the imported value does not, clean or re-enter the source values as dates; for a known year, month, and day, the DATE function can build a proper date from those parts. Check a sample before applying a conversion to a whole column.

A date changes after you press Enter. Sheets may have interpreted the entry using a different locale or an automatic date pattern. Undo immediately if needed, then confirm the locale and enter the date with a month name or construct it with DATE. If you intended to preserve the characters exactly rather than create a date value, enter an apostrophe first and treat the result as text.

The shortcut does not insert a date. Click a cell first, check whether the browser or operating system is intercepting the key combination, and try the equivalent for your platform: Ctrl+; on Windows or ⌘+; on Mac. Keyboard layouts may map punctuation differently. You can always type the current date and then format the cell using the Format menu.

Frequently Asked Questions

How do I enter today’s date in Google Sheets?
Type the date directly, or select a cell and use Ctrl+; on Windows or ⌘+; on Mac to insert today’s date as a fixed value. Use =TODAY() only if you want a formula that can update over time.

How do I write a date as day/month/year?
Set the spreadsheet locale to a region that uses that convention, or choose a custom date format with day, month, and year in that order. Verify the underlying dates when entries were originally ambiguous.

Can I type a date as YYYY-MM-DD?
You can enter that convention, but parsing still depends on Sheets’ recognition and spreadsheet settings. Check that the result behaves as a date—for example, apply a date format and verify it sorts chronologically—rather than assuming the appearance means it is stored as a date.

Why does Google Sheets turn my date into a number?
A date is stored as a number internally. Select the cell and apply Format > Number > Date to display it as a date. If formatting has no effect, the entry may be text instead.

How do I stop Sheets from changing what I type?
If you need to preserve the exact characters as text, start the entry with an apostrophe. If you need a working date value, use an unambiguous date, confirm the locale, and apply the display format you want instead of forcing the entry to text.

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.