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

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

Hi Tiffany,

you could use

=if(today()date(2006,08,31),date(2006,08,31),toda y())

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Tiffany C." escreveu:

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