Excel Date Shortcut: Insert Today’s Date with Ctrl+;

How-to basics · Updated November 18, 2026

In Excel for Microsoft 365 on Windows, press Ctrl+; (Ctrl plus the semicolon key) to insert today’s date into the selected cell. It enters a fixed date value, not a formula, so the date will not change tomorrow.

How to insert today’s date in Excel

To add the current date, first select the cell where it should appear, then press Ctrl+;. Excel uses the date from your computer’s system clock. The value stays in the cell after you save, close, and reopen the workbook.

  1. Click the destination cell. If you are editing the contents of a cell, press Enter or Esc first so the cell is no longer in edit mode.
  2. Hold down Ctrl and press the semicolon key. On a typical US keyboard, semicolon is the unshifted key beside L.
  3. Check that the displayed date is the one you expect. If needed, adjust the cell’s number format.

The shortcut is useful for dated notes, sign-off fields, logs, and forms where the entry should record the date it was made. It saves typing and avoids accidentally entering a different date format. It inserts the date into the active cell; it does not add a date to every selected cell or create a running calendar.

What Ctrl+; puts in the cell

Excel stores dates as numeric values and displays them using a date format. The shortcut inserts the current date as a value, rather than inserting characters that merely look like a date. That distinction matters when you sort dates, calculate elapsed days, or filter a table by date: a genuine Excel date can be used in those operations.

The value is static. If you enter a date on Monday, that cell still represents Monday when you open the workbook on Tuesday. Editing your computer’s clock later does not automatically revise a date already inserted with the shortcut. The visible appearance, however, depends on the cell’s number format and your regional settings. For example, the same date might display as 11/2/2026, 2/11/2026, or 2-Nov-2026 in different formats or locales.

Excel’s date system represents dates as serial numbers, which is why a date can be used in calculations. If a cell displays a number such as 46328 instead of a calendar date, the date value may be present but the cell is formatted as General or Number. Apply a date format rather than retyping the entry.

Fixed date versus the TODAY function

Choose the shortcut when you want to record the date at the moment of entry. Choose the TODAY function when you want a cell to show the current date as the workbook recalculates. A TODAY formula is dynamic, so its displayed result can change on a later day; the Ctrl+; entry is a fixed record.

In a blank cell such as A1, with no source range required, enter =TODAY() to display the current date. The formula has no arguments. Excel recalculates it according to the workbook’s calculation settings, including when the workbook is recalculated or opened. It does not continuously tick forward every second.

This difference is important in templates. A TODAY formula in an invoice header can be appropriate if the sheet is meant to show the date whenever it is opened. It is a poor choice for a permanent transaction date if the date must remain the one on which the transaction was recorded. For that kind of record, enter the date with Ctrl+; or use another controlled timestamping process.

In a blank cell such as B1, again with no input range required, enter =NOW() to show the current date and time. NOW is dynamic too: its result can update when Excel recalculates. Use the shortcut for a fixed time or date-time record instead of NOW when the value should not later move.

Formatting the inserted date

If Excel shows the date in an unfamiliar style, change how it is displayed rather than replacing the underlying value. Select the cell and use Home > Number, then choose a format from the Number Format list, such as Short Date or Long Date. For more control, open the Format Cells dialog with Ctrl+1, choose the Number tab, and select Date or Custom.

Custom formats can make dates easier to read in reports. For example, a format such as ddd, mmm d, yyyy displays a weekday, abbreviated month, day, and year, such as Mon, Nov 2, 2026. Formatting changes the display, not the date value itself. If another person opens the workbook with different regional settings, a numeric date format may look different, so an unambiguous month-name format can help when sharing files internationally.

Be careful when typing dates manually into cells. Depending on regional settings, an entry such as 3/4/2026 can mean March 4 or April 3. Ctrl+; avoids that particular ambiguity because Excel inserts the computer’s current date as a date value. It does not, however, override a deliberately unusual custom display format.

Entering the current time or both date and time

Excel has a related shortcut for a fixed time: press Ctrl+Shift+;. It enters the computer’s current time as a value. As with the date shortcut, the value does not keep updating after entry, though its displayed appearance depends on the cell format.

To enter a fixed date and time in one cell, use the date shortcut, press Space, and then use the time shortcut: Ctrl+;, Space, Ctrl+Shift+;. This is a sequence of key presses, not one combined shortcut. Make sure the cell is formatted to show both date and time; otherwise the value may be stored correctly while part of it is hidden by the display format.

A fixed timestamp can help document when a status was updated, but it is not a secure audit trail. Anyone with editing access may be able to change the cell, and the timestamp relies on the computer clock being correct. For regulated or tamper-resistant records, use an appropriate system with access controls and an audit history rather than relying on a manually entered spreadsheet value alone.

Windows and Mac keyboard differences

On Windows, use Ctrl+; for the date and Ctrl+Shift+; for the time. In Excel for Mac, the date shortcut is generally Control+; as well; the Control key is meant here, not Command. Keyboard layouts can change which physical key produces a semicolon, so use the key that types a semicolon on your layout. If a shortcut is intercepted or does not work, check Excel’s shortcut help for your installed version and keyboard configuration.

On some non-US keyboards, typing a semicolon itself may require Shift or another key combination. That can make the shortcut feel different from the US-keyboard instruction. The important point is to invoke the semicolon keystroke while holding the relevant modifier, rather than substituting Ctrl+D. Excel for the web and browser settings can also affect keyboard input, so a desktop shortcut may behave differently in a browser environment.

Common problems and quick fixes

  • The shortcut does nothing: Confirm that a cell is selected and that you are not currently editing the cell. A protected worksheet may also prevent entries in locked cells. Try an unlocked cell or ask the workbook owner about protection.
  • A number appears instead of a date: The value may be stored correctly but displayed with a General or Number format. Select the cell and choose Short Date from the Home tab’s Number Format list.
  • The date looks wrong: Check the computer’s date and regional settings, then inspect the cell’s format. The shortcut uses the system date; it does not infer a preferred date from the workbook’s labels.
  • The date changes the next day: The cell may contain =TODAY() rather than a shortcut-entered value. Click the cell and inspect the formula bar. A formula beginning with an equals sign is dynamic; a fixed date is a stored value.
  • The shortcut changes something else: Make sure you are using the semicolon key and not a nearby key. On a different keyboard layout, the physical position may not match a US keyboard.

How Ctrl+; compares with other date-entry methods

Manual typing is useful when entering a date other than today, such as a scheduled deadline or historical event. It is also necessary when the desired date is not the date on the computer. Use a clear format or a month name when ambiguity between day and month is possible.

Ctrl+; is best for a quick, fixed entry of today’s date. =TODAY() is better when the cell should reflect the date at recalculation time. A manually typed value is better for a different date. For a fixed date-and-time stamp, combine the date and time shortcuts. These methods look similar once formatted, but they behave differently when the workbook is opened later.

One related keyboard shortcut is Ctrl+D, which fills the selected range downward from its top cell. It does not mean insert today’s date. If A2 contains a date and you select A2:A10 before using Ctrl+D, Excel copies the top cell’s content downward; that is a fill operation, not a command to create today’s date or a sequential date series.

Frequently Asked Questions

What is the Excel shortcut for today’s date?
Press Ctrl+; in Excel for Windows after selecting the cell. It inserts today’s date as a fixed value.

Does Ctrl+; update automatically tomorrow?
No. The shortcut inserts a static date. Use =TODAY() in a cell if you want a date that can update when Excel recalculates.

How do I insert the current time in Excel?
Press Ctrl+Shift+; on Windows. It inserts the current time as a fixed value, not a continuously updating clock.

Why does Excel show a number instead of my date?
The cell may be formatted as General or Number. Select it and choose a date option under Home > Number Format, or open Format Cells with Ctrl+1 and select a date format.

Is Ctrl+D the date shortcut?
No. Ctrl+D fills downward from the top cell in a selected range. Use Ctrl+; to enter today’s date.

Does the date shortcut work on a Mac?
Excel for Mac generally uses Control+; for the date. Use Control rather than assuming Command, and account for the semicolon position on your keyboard layout.

Related

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.