VBA & Macro Problems

How to Add a Static Current Date in Excel Without Changing History

Maira Mehtab Sep 22, 2026 871 views

Question details

The user needs to record the current date in a new row of a compliance tracker while ensuring that all previously entered dates remain permanent and unchanged.

Product: Microsoft Excel
Device & OS: not provided
Scenario: Adding new entries to a compliance tracker where the exact date of entry must be logged and preserved as a historical record.
Observed behavior: Using the standard TODAY() formula causes all dates in the column to update to the current date every day, destroying the historical accuracy of previous entries.

Before you start

Identify the exact columns in your tracker where the date and the triggered data entry will be located. If you plan to automate this, ensure your workbook is saved as a Macro-Enabled Workbook (.xlsm).

Solution 1

Use Keyboard Shortcuts for Manual Static Date Entry

If you are entering data manually, the fastest way to add a static current date without using formulas is by utilizing a built-in keyboard shortcut.

Select the target cell

Click on the specific cell in the new row where you want the current date to appear.

Insert the static date

Press 'Ctrl' + ';' (semicolon) on your keyboard. This action instantly inserts the current date as a hardcoded value that will never change.

Press Enter

Press the Enter key to confirm the entry and move to the next cell.

Solution 2Recommended

Automate Static Date Insertion Using a VBA Macro

Use a VBA macro to automatically stamp a static date when a new compliance entry is saved or modified, bypassing the dynamic nature of the TODAY() function.

Efficient Data Tracking

Manage Macros and Static Dates Seamlessly in WPS Spreadsheet

WPS Spreadsheet provides comprehensive support for VBA macros and keyboard shortcuts, enabling you to build automated compliance trackers without losing historical data. Enjoy a seamless, highly compatible environment for your daily tracking needs.

1. Download and Install WPS Office: Get WPS Office from the official website and open your existing compliance tracker.
2. Access the Developer Tools: Navigate to the 'Developer' tab on the ribbon to access the VBA Editor for your automation scripts.
3. Apply Static Dates: Use the shortcut 'Ctrl + ;' or configure your custom VBA script to automatically log historical dates exactly as you need.

Fully compatible with Microsoft Excel .xlsx and .xlsm formatsNative support for running and editing VBA macrosSupports identical keyboard shortcuts (Ctrl + ;) for instant static date entryFree, lightweight, and features a user-friendly tabbed interface

microsoft office alternative - wps office

Frequently Asked Questions

Why does the TODAY() function change my past dates?

The TODAY() function is a volatile formula in Excel. This means every time the workbook is opened, edited, or recalculated, the formula checks your computer's system clock and updates to the current date, making it impossible to use for preserving static historical records.

Can I convert existing TODAY() formulas into static dates?

Yes. Select the cells containing the TODAY() formula, copy them by pressing 'Ctrl + C', then right-click the same selection and choose 'Paste as Values' (the clipboard icon with '123'). This removes the underlying formula and leaves only the static text of the date.

Is it possible to add a static time along with the date?

Yes. If entering manually, you can press 'Ctrl + ;', hit the Spacebar, and then press 'Ctrl + Shift + ;' to insert both the static date and the static current time. If using VBA, use the 'Now' function instead of 'Date' to capture both.

Excel & Data Problems