Forum Discussion
Solved
How to use today's date for invoicing, copied sheets
How to use today's date for an invoice template, and keep the date for each copie ( printed) but when I duplicate this sheet in the workbook for each invoice as a reference, the date changes for tho...
Don't use a formula. You can enter the current date as a fixed value by pressing Ctrl+;
Alternatively, you could use VBA code to create a duplicate of the template sheet and enter the current date in the relevant cell of the copy.
Don't use a formula. You can enter the current date as a fixed value by pressing Ctrl+;
Alternatively, you could use VBA code to create a duplicate of the template sheet and enter the current date in the relevant cell of the copy.