Document Editing Problems

How to Enter a Fixed Invoice Date in Excel Without Automatic Updates

Chanuka GeekiyanageChanuka Geekiyanage Nov 10, 2026 870 views

Question details

The user needs to insert today's date into an Excel invoice template in a way that prevents it from updating automatically when the file is reopened or copied.

How to Enter a Fixed Invoice Date in Excel Without Automatic Updates
Product
Excel
Device & OS
not provided
Scenario
Creating or managing invoice templates where the issue date must remain permanent.
Observed behavior
Using standard date functions like TODAY() causes the invoice date to change to the current day every time the file is opened, which ruins historical invoice records.
Before you start

Check the cell formatting of your invoice date field to ensure it is set to 'Date' rather than 'Text' or 'General', so your fixed date displays correctly after insertion.

Solution 1Recommended

Use a Keyboard Shortcut to Insert a Static Date

The quickest and most reliable way to enter a permanent date is using Excel's built-in keyboard shortcut.

The TODAY() or NOW() functions are dynamic and will recalculate every time the workbook is opened. To keep a date fixed for an invoice, you must enter it as a static value.

1
Select the target cell

Click on the cell in your invoice template where you want the fixed date to appear.

2
Use the shortcut

Press the 'Ctrl' and ';' (semicolon) keys on your keyboard at the same time.

3
Confirm the entry

Press 'Enter'. The current date is now hard-coded into the cell and will remain the same no matter when you reopen the file.

Use a Keyboard Shortcut to Insert a Static Date
Add current time: If your invoice also requires a fixed timestamp, press Ctrl + Shift + ; (semicolon) to insert the current time as a static value.
Efficient Spreadsheet Management

Create and Manage Invoices Easily with WPS Office

WPS Spreadsheet provides a seamless, free alternative for all your billing and invoice template needs. You can easily enter fixed dates using familiar shortcuts, design professional invoices, and export them directly to PDF.

  1. 1. Download and install: Get WPS Office from the official website and open WPS Spreadsheet.
  2. 2. Open your invoice: Load your existing Excel invoice template or choose a new one from the built-in WPS template library.
  3. 3. Enter a fixed date: Click the designated date cell and press Ctrl + ; to instantly add a permanent date.
  4. 4. Save or export: Save your document in .xlsx format or click 'Export to PDF' from the menu to finalize your invoice and lock all edits.
Fully compatible with Microsoft Excel formats (.xlsx, .xls)Built-in free invoice templates to jumpstart your billing processOne-click export to PDF to lock in all dates and values securelyLightweight software that runs smoothly on older devices
microsoft office alternative - wps office

Frequently Asked Questions

Why does my invoice date keep changing to today's date?

This happens if you are using the =TODAY() or =NOW() formula in your date cell. These formulas are volatile and update automatically based on your system clock whenever the file is opened or printed.

How can I convert an existing TODAY() formula into a static date?

Select the cell containing the formula, press Ctrl + C to copy it, then right-click the exact same cell and choose 'Paste as Values' (the clipboard icon with a 123 on it). This removes the formula and leaves only the fixed date behind.

Does the Ctrl + ; shortcut work on Mac computers?

Yes, on spreadsheet software for Mac, you can generally use the Control + ; shortcut (or Command + ; depending on your specific keyboard layout and OS version) to insert the current date as a static value.

Can I lock the date cell so no one can change the fixed date?

Yes. After inserting your fixed date, right-click the cell, select 'Format Cells', go to the 'Protection' tab, and check 'Locked'. Then, navigate to the 'Review' tab on the ribbon and click 'Protect Sheet' to enforce the lock.