Shortcuts for Current Date and Time in Excel
The fastest way to insert the current date in Excel is Ctrl+; (semicolon) and the current time is Ctrl+Shift+; (semicolon). Pressing Ctrl+; enters today’s date as a static value, while Ctrl+Shift+; enters the current time as a static value; combining them with a space or in separate cells gives you both.
Why Static vs. Dynamic Matters
The shortcuts above insert a static snapshot—the value does not change when you reopen the file or recalculate. This is ideal for timestamps that should record when data was entered, such as order logs, attendance sheets, or invoice creation dates. If you need the date or time to update automatically every time the sheet recalculates, use the functions =TODAY() for the current date and =NOW() for the current date and time. These are volatile functions, meaning they refresh whenever Excel recalculates (e.g., when you open the workbook or change any cell).
The Full Shortcut List
- Ctrl+; – Insert current date (static)
- Ctrl+Shift+; – Insert current time (static)
- Ctrl+; then space then Ctrl+Shift+; – Insert date and time in one cell (static, separated by a space)
- =TODAY() – Dynamic current date (updates on recalculation)
- =NOW() – Dynamic current date and time (updates on recalculation)
Note: On some keyboards, especially laptops, you may need to use the Fn key if the semicolon is shared with another function. For example, Ctrl+Fn+; might be required on certain models.
How to Format the Result
After inserting a date or time, Excel uses the default date/time format of your system. To change it, select the cell(s), right-click, choose Format Cells (or press Ctrl+1), and pick a format under the Number tab. For dates, you can choose from options like dd/mm/yyyy or mmmm d, yyyy. For times, you can select h:mm AM/PM or hh:mm:ss. If you want to combine date and time in one cell, you can type the date, press Ctrl+Shift+; after a space, and then format the cell with a custom format like dd/mm/yyyy hh:mm.
Common Problems and Solutions
- Shortcut inserts a date but it shows as a number (e.g., 45234): The cell is formatted as General or Number. Apply a date format via Ctrl+1.
- Shortcut inserts the time but it shows as a decimal (e.g., 0.75): Same issue—apply a time format.
- The date or time changes when I reopen the file: You likely used =TODAY() or =NOW(). To make it static, replace the formula with the value: copy the cell, right-click, Paste Special > Values.
- Shortcut doesn’t work on a Mac: On Mac Excel, the shortcuts are Cmd+; for date and Cmd+Shift+; for time.
- Shortcut inserts the previous day’s date: This can happen if your system time zone is ahead of UTC and Excel’s date serial number is based on UTC. Check your system date/time settings; it’s usually correct, but if you’re in a time zone like UTC+14, the date may appear off by one.
Comparing Shortcuts vs. Functions
Choosing between shortcuts and functions depends on your need:
| Method | Updates? | Use case |
|---|---|---|
| Ctrl+; | No | Logging when data was entered |
| Ctrl+Shift+; | No | Logging time of entry |
| =TODAY() | Yes | Always show today’s date (e.g., in a report header) |
| =NOW() | Yes | Live timestamp for calculations |
Remember that volatile functions recalculate every time Excel recalculates, which can slow down large workbooks. For static entries, always prefer the shortcuts.
Frequently Asked Questions
How do I insert both date and time in one cell with a shortcut?
Press Ctrl+;, then press Space, then press Ctrl+Shift+;. This inserts the date, a space, and the time as a static value. Format the cell with a custom format like dd/mm/yyyy hh:mm to display both properly.
Why does my date shortcut insert a time instead?
This is unlikely, but if it happens, check your keyboard layout. Some non-US layouts have the semicolon key in a different position. Also, ensure you’re not accidentally pressing Shift with the first shortcut. The date shortcut is Ctrl+; and the time shortcut is Ctrl+Shift+;.
Can I make the shortcut insert a date that updates automatically?
No, the shortcuts always insert static values. For an auto-updating date, use the formula =TODAY(). If you need both date and time that update, use =NOW().
How do I change the date format after using the shortcut?
Select the cell, press Ctrl+1 to open Format Cells, go to the Number tab, choose Date or Custom, and pick the format you want. You can also use the Number Format dropdown in the Home tab.
What if the shortcut inserts a number like 45234 instead of a date?
That’s Excel’s serial number for the date. The cell is formatted as General or Number. Apply a date format (Ctrl+1) to display it as a date. The serial number is the number of days since January 0, 1900.
Does the shortcut work in Excel Online or Google Sheets?
In Excel Online, the shortcuts are the same. In Google Sheets, the shortcuts are Ctrl+; for date and Ctrl+Shift+; for time, but they insert static values as well. For dynamic dates in Sheets, use =TODAY() and =NOW().
Related
Method: the standard formula for this calculation, rounded as each result states. See how the calculators work or report an error.