How to Enter a Fixed Invoice Date in Excel Without Automatic Updates
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.

- 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.
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.
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.
Click on the cell in your invoice template where you want the fixed date to appear.
Press the 'Ctrl' and ';' (semicolon) keys on your keyboard at the same time.
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 VBA to Generate a Fixed Date on Copied Sheets
Ideal for users who use a master invoice template and want to automatically duplicate it with today's fixed date.
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. Download and install: Get WPS Office from the official website and open WPS Spreadsheet.
- 2. Open your invoice: Load your existing Excel invoice template or choose a new one from the built-in WPS template library.
- 3. Enter a fixed date: Click the designated date cell and press Ctrl + ; to instantly add a permanent date.
- 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.

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.




