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€¦..

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€¦..

Hi,

1. You could enter the date manually with Ctrl ; (control + semi-colon)
That enters the current data as a static number.
2. Otherwise you will need to use VBA because there is no way of making
TODAY() both static and dynamic at the same time.
3. Or After you copy the sheet you can manually go to the original sheet
(the old today) and copy Paste Special, Values.

--
Thanks,
Shane Devenshire


"3Nails" wrote:

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€¦..

Thanks for the response. I thought that might be the answer.....

"3Nails" wrote:

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€¦..