Why Excel Date Values Change and How to Enter a Fixed Timestamp
Question details
The user wants to understand why earlier date values change and enter a fixed date and time that does not recalculate.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Entering date-related values in worksheet cells and recording a fixed timestamp.
- Observed behavior
- Earlier cells appear to update when a later cell is entered.
Select an affected cell and check the formula bar to see whether it contains a formula such as NOW(), TODAY(), or DATE(). The keyboard shortcuts below are for Excel on Windows.
Insert a fixed date and time in Excel
Use keyboard shortcuts or type a timestamp when you need a value that will not recalculate.
Click the cell where you want to record the timestamp.
In Excel for Windows, press Ctrl+; to insert the current date, type a space, and then press Ctrl+Shift+; to insert the current time. Press Enter to finish.
Select the cell, press Ctrl+1, and choose a date-and-time format under Number. Alternatively, choose Custom and enter yyyy-mm-dd hh:mm.

Check date formulas that appear to change
Inspect the formula and its references to find out why an earlier cell recalculates.
Enter a fixed timestamp in WPS Spreadsheet
Use WPS Spreadsheet to type a fixed date and time, format it for readability, and save your workbook in an Excel-compatible format.
- 1. Open the workbook: Open WPS Spreadsheet and select File > Open to choose your workbook.
- 2. Enter the timestamp: Click the target cell, type a date and time such as 2026-06-15 14:30, and press Enter.
- 3. Set the display format: Select the cell, press Ctrl+1, and choose a date-and-time format or a custom format such as yyyy-mm-dd hh:mm.
- 4. Save the workbook: Select File > Save As and choose XLSX if you want to keep an Excel-compatible copy.

Frequently Asked Questions
Why does my Excel timestamp keep changing?
A timestamp created with =NOW() can change when the workbook recalculates. Select the cell and check the formula bar; use a typed value or the fixed-date and time shortcuts instead if it must stay unchanged.
Does the DATE function automatically update to the current date?
No. DATE requires year, month, and day arguments, such as =DATE(2026,6,15). Its result changes only if its inputs change.
How do I insert just the current date in Excel?
In Excel for Windows, select a cell, press Ctrl+;, and then press Enter. This inserts a fixed date rather than a recalculating formula.
How can I show both the date and time in a cell?
Select the cell, press Ctrl+1, and choose a date-and-time format. You can also use a custom format such as yyyy-mm-dd hh:mm.




