How to Add Date and Time Stamps in Excel (Static and Dynamic)

Excel has two ways to stamp a date or time into a cell: a static stamp that locks in the moment you press the keys, and a dynamic stamp that updates every time the workbook recalculates. Picking the wrong one will silently break your formulas or your logs, so it’s worth knowing exactly which method to use.

Static Date and Time Stamps (Keyboard Shortcuts)

Use these when you want to record a specific moment, an invoice date, a task completion time, a log entry. The value will never change after you enter it.

Method #1: Insert the current date

1. Click the cell where you want the date.
2. Press Ctrl + ; (hold Ctrl, tap the semicolon key).
3. Press Enter to confirm.

The date is now locked in. Reopening the file or pressing F9 will not change it.

Method #2: Insert the current time

1. Click the cell where you want the time.
2. Press Ctrl + Shift + : (hold Ctrl and Shift, tap the colon/semicolon key).
3. Press Enter to confirm.

Like the date shortcut, this is a snapshot, it will not tick forward.

Method #3: Insert both date and time in the same cell

1. Click the cell where you want the combined stamp.
2. Press Ctrl + ; to enter the date.
3. Press Spacebar (do not press Enter yet).
4. Press Ctrl + Shift + : to append the time.
5. Press Enter to confirm.

The cell will display something like 5/13/2026 9:42 AM. If it looks wrong, press Ctrl + 1 to open Format Cells, go to the Number tab, and pick a combined date/time format under Custom (for example, mm/dd/yyyy h:mm AM/PM).

Dynamic Date and Time Stamps (Formulas)

Dynamic stamps update automatically every time the workbook opens or recalculates. Use these when a formula elsewhere depends on today’s date, or when you want a “last updated” indicator. Do not use them in logs or invoices, the value will change every time someone opens the file.

Method #4: Insert a dynamic date with =TODAY()

1. Click the cell where you want the date.
2. Type =TODAY() and press Enter.

Excel updates this to the current date every time the workbook recalculates (F9) or reopens.

Method #5: Insert a dynamic date and time with =NOW()

1. Click the cell where you want the date and time.
2. Type =NOW() and press Enter.

To show only the time from =NOW(), format the cell as Time: press Ctrl + 1, go to the Number tab, and select Time. The date portion is still stored internally, it just won’t display.

Automatic Static Timestamp When a Cell Is Filled (No VBA)

This is the method most inventory trackers and task logs actually need: stamp the exact time a row was completed, and never change it afterward. You can do it without VBA using an iterative formula.

Method #6: Use an iterative formula for event-triggered timestamps

This example stamps column H when you enter anything in column F (e.g., marking a task complete).

1. Go to File > Options > Formulas.
2. Check Enable iterative calculation, set Maximum Iterations to 1, and click OK.

3. Click cell H5 (or whichever cell should hold the timestamp).
4. Enter this formula:
   =IF(F5<>"",IF(H5="",NOW(),H5),"")
5. Press Enter.

Now type anything into F5, the current date and time will stamp into H5 and stay there even when you reopen the file. The iterative calculation setting is saved per workbook, so it won’t affect other files.

Heads up: If you see a circular reference warning instead of a timestamp, double-check that iterative calculation is enabled (step 1–2 above). That setting is what allows the formula to reference its own cell safely.

Formatting Your Date or Time Cell

If your stamp shows a number like 46189 instead of a date, or 0.42 instead of a time, the cell is formatted as General or Number. Fix it fast:

1. Select the cell.
2. Press Ctrl + 1 to open Format Cells.
3. On the Number tab, choose Date, Time, or Custom.
4. For a custom format that shows both, enter: mm/dd/yyyy h:mm AM/PM
5. Click OK.

Quick Reference: Which Method Should You Use?

Conclusion

For most people, Ctrl + ; is all they’ll ever need, it’s instant, it never changes, and it works in every version of Excel. If you’re building a tracker where rows auto-stamp on completion, the iterative formula in Method #6 is the cleanest no-VBA solution and worth the two minutes of setup. The one mistake to avoid: using =NOW() in a log, then wondering why all your timestamps show the same time every time you open the file.

For more on working with dates in Excel, see how to convert dates to numbers in Microsoft Excel or show dates as days of the week in Microsoft Excel. If your Excel formulas are not working or calculating as expected after adding these stamps, that guide covers the most common causes. You can also learn more about the TODAY function and the NOW function on Microsoft’s official support pages. For background on how Excel stores date and time values internally as serial numbers, the Excel date system documentation is a useful reference.