Save Today() in cell
Hi
=TODAY()
is a a volatile function which will re-calculate whenever the sheet is
refreshed.
Either copy the cellPast SpecialValues to "fix" the date
Or
use Control+; (Control+semicolon) to enter Today's date into a cell in a
non-volatile manner.
--
Regards
Roger Govier
"3Nails" wrote in message
...
I want to automatically save the current date in cell €śA1€ť. After saving
the
sheet I will then copy the current sheet for tomorrows activity. I would
like the new current date to be automatically saved in the new sheet when
opened the next day. Basically have current date never change once it is
automatically updated in sheet. Any quick fix? Thanks€¦..
|