How do I get the date to remain static when a sheet is saved and not change
to the current date when it is re opened. It is a daily log and each shift
it will be opened to update. I would like the date to autopopulate the
current date but when it is saved it needs to remain that date. Each shift
will be saving the file under a new name. When they reopen the master it
needs to put the next current date in.

The users won't know to do the ctrl keys to make the date static. I need to
make it as automated as I can.

Thanks in advance for your assistance.
--
Thanks,
Angie