Excel Shortcut Keys for Date: Insert and Format Dates

In Excel for Microsoft 365 on Windows, press Ctrl+; (Ctrl plus the semicolon key) to enter today’s date as a fixed value in the selected cell. On a Mac, use Control+;. The shortcut inserts a date that will not change tomorrow; use the =TODAY() formula instead when the date should update automatically.

The shortcut for entering today’s date

Select the cell where the date belongs, then press Ctrl+; on Windows. Excel puts the current date into that cell immediately. You do not need to type an equals sign or open a menu. The inserted value is static: it records the date at the moment you pressed the shortcut, so it remains the same when the workbook is reopened on another day.

For example, if the computer’s date is November 2, 2026, the cell receives that date. Its visible appearance depends on the cell’s number format and regional settings: it could show as 11/2/2026, 2-Nov-2026, or another valid date style. The shortcut supplies the date value; it does not force one particular display format.

Windows: Ctrl+; (hold Ctrl and press the semicolon key).
Mac: Control+; (use Control, not Command).
Excel for the web: Ctrl+; is commonly available, though browser or keyboard settings can affect shortcut behavior.

With a typical US keyboard, the semicolon is the unshifted key beside L. On some international layouts, the key arrangement differs. If the keystroke does not insert a date, check the keyboard layout and use the menus or type a date in a format Excel recognizes.

What the date shortcut actually inserts

Excel dates are stored as numeric values and displayed according to a cell’s date format. The shortcut enters the current date as a value, rather than creating a formula that checks the clock each time the worksheet recalculates. That distinction is useful for records such as the date an order was received, a form was completed, or a task was reviewed: the historical entry should usually stay fixed.

The operating system’s current date is the source for the shortcut. If the computer clock or date is wrong, Excel may insert an incorrect date too. The shortcut also does not automatically add a label, timestamp, or date to every row in a table; it inserts the value in the selected cell. You can then copy or fill the value where appropriate.

A date may look different on another computer because regional settings determine whether the month or day comes first and which separator is used. For instance, 4/5/2026 can mean April 5 or May 4 depending on the locale. When a workbook will be shared, an unambiguous display such as 5-Apr-2026 can make dates easier to interpret.

Format the inserted date

If Excel displays the result as a number, the date may still be present; the cell may simply be formatted as General or Number. Select the cell and choose Home > Number Format, then select Short Date or Long Date. Short Date uses a compact numeric style, while Long Date spells out the weekday and month name. The exact appearance can vary with regional settings.

On Windows, Ctrl+Shift+# applies Excel’s built-in date number format to the selected cell. It changes how the value is displayed, not the date itself. If you need a particular style, use the Number Format dropdown or open Format Cells and select a date format. A custom format can also show a four-digit year or month name, for example, without changing the underlying value.

Formatting is separate from entering a date. Pressing the date shortcut in a cell already formatted as text may not produce the expected date display, and changing a cell to a date format cannot reliably turn every text string into a real date. If you are unsure, select the cell and inspect the Number Format dropdown, then check whether Excel recognizes the entry as a date value.

Static dates versus automatically updating dates

Use the shortcut when you want a date that stays put. Use a formula when the date should reflect the current day whenever Excel recalculates the workbook. With A2 as the cell where the changing date should appear, enter =TODAY(). It returns the current date according to the computer’s date settings and updates during recalculation; it does not preserve the date on which you first entered the formula.

This difference matters in logs and templates. A fixed date is appropriate for a completed transaction or a dated sign-off. A formula is useful for a dashboard label such as today’s date, or for calculating how many days remain until a deadline. If a formula-based date is used in a record that must never change, copy the cell and use Paste Special > Values to replace the formula with its current result.

Excel’s =TODAY() result may not visibly update at the instant midnight passes if the workbook is open; recalculation behavior and workbook calculation settings affect when formulas refresh. By contrast, Ctrl+; captures the computer’s date at the time of the keystroke and does not recalculate.

Enter a fixed date and time together

Excel has a separate shortcut for the current time: Ctrl+Shift+; on Windows and Control+Shift+; on a Mac. To place a fixed date and time in one cell, press the date shortcut, press Space, and then press the time shortcut. The space separates the two values in the entry. Excel stores the date and time together, although the cell’s format determines whether both parts are visible.

If the cell shows only a date, apply a date-and-time format through Format Cells or choose a suitable custom format. If it shows a decimal number, that is the underlying numeric representation and the cell needs an appropriate date/time format. The shortcut records a fixed timestamp; it does not keep a live clock running in the cell.

Use a combined timestamp when the exact time matters, such as when noting when a job was checked. For a simple due-date column, a date alone is usually clearer. Avoid adding a time merely because Excel supports it: hidden time values can affect comparisons and calculations even when the cell appears to show only a date.

Common problems and how to fix them

The cell displays a serial-looking number. Select it and apply Short Date or another date format from Home > Number Format. The value may already be a valid date.
The shortcut types punctuation instead. Check whether the keyboard layout requires a different key combination to produce a semicolon, and confirm that Excel has focus. On a laptop or non-US keyboard, key placement can differ.
The date is wrong by a day or more. Check the computer’s date, time zone, and regional settings. Excel’s shortcut uses the system date rather than asking which date you intended.
The date changes when the workbook opens. Check whether the cell contains =TODAY() rather than a fixed date value. A formula recalculates; the shortcut’s inserted value does not.
Month and day appear reversed. The display follows locale conventions. Use a month-name format such as 2-Nov-2026 to reduce ambiguity, or confirm the workbook’s regional expectations before sharing.
The cell treats the entry as text. Check the cell format and the date order Excel expects. A text value may need conversion before sorting or date arithmetic will work correctly.

One common misconception is that applying a date format converts any entry into a true date. Formatting changes the presentation of a value; it does not guarantee that text has been parsed as a date. If sorting places a date unexpectedly or a calculation cannot use it, verify that Excel recognizes the cell as a numeric date rather than text.

Choosing the right date-entry method

The best method depends on whether you need speed, repeatability, or a changing result. For a one-off entry in a worksheet, the keyboard shortcut is quick and creates a fixed value. Typing a date is useful when the date is not today, but enter it in a format Excel can interpret correctly. A formula is better when the displayed date should track the current day.

Today, permanently recorded: select the cell and press Ctrl+;.
Today, refreshed by recalculation: use =TODAY().
A different known date: type the date using an unambiguous format, then confirm the cell is recognized as a date.
A fixed date and time: insert the date, a space, and the time shortcut.
A preferred appearance: enter the date first, then choose the desired date format.

In a shared workbook, consider using a clear column heading such as Date entered or Review date. A clear heading explains what the date represents; a cell’s date format alone cannot communicate whether it is a creation date, deadline, or last-updated date.

Frequently Asked Questions

What is the Excel shortcut for today’s date?

On Windows, select a cell and press Ctrl+;. On a Mac, press Control+;. Excel enters the computer’s current date as a fixed value.

Does Ctrl+; update the date every day?

No. The shortcut inserts a static date that stays unchanged. Use =TODAY() if you want a formula to return the current date when the workbook recalculates.

How do I insert the current date and time in Excel?

Press Ctrl+; on Windows, press Space, then press Ctrl+Shift+;. On a Mac, use Control with the corresponding semicolon shortcuts. Apply a date-and-time format if the cell does not show both parts.

Why does Excel show a number instead of a date?

The cell may be using General or Number format. Select it and choose Home > Number Format > Short Date. A number display can be the date’s stored value rather than evidence that the shortcut failed.

Is the Mac shortcut Command+;?

No. The current-date shortcut uses Control+; in Excel for Mac, not Command+;. The time shortcut uses Control+Shift+;.

Can I use the date shortcut to enter a date other than today?

No. It inserts the current system date only. For another date, type the intended date in a format Excel recognizes, then verify its display and value.

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.