Forum Discussion

AnnieMaisonneuve's avatar
AnnieMaisonneuve
Copper Contributor
Jan 09, 2025

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 those when I open my workbook

 

Facture 01 and Facture 02 : when I duplicate this sheet in the workbook for each invoice as a reference, the date changes for those when I open my workbook

  • 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.

Resources