Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Set todays date in a cell but then fix it.

Is it possible to get today's date entered automatically into a cell, but then to fix it so that the entered date remains unchanged. I have tried the today() function, but the date changes each time I reopen the spreadsheet. I'm looking to see if there's a quicker method than having to enter the date manually each time.