Check he
http://www.mcgimpsey.com/excel/timestamp.html
"Tiffany C." wrote in message
...
I am using some Now() functions to show the date on current month reports,
but when those reports are opened in succeeding months the dates then
change
to the new current month. Is there a way to keep the data automated but
at
month end lock the field? As opposed to copying and saving the date as a
value.
Thanks for any help on this.
Tiffany