Is there a way to Lock down a date formula?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tiffany C. - 17 Aug 2006 19:34 GMT

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

Reply to this Message

PCLIVE - 17 Aug 2006 20:02 GMT

Check here:

http://www.mcgimpsey.com/excel/timestamp.html

>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
[quoted text clipped - 6 lines]
> Thanks for any help on this.
> Tiffany

Reply to this Message

Marcelo - 17 Aug 2006 20:47 GMT

Hi Tiffany,

you could use

=if(today()>date(2006,08,31),date(2006,08,31),today())

hth

Signature

regards from Brazil
Thanks in advance for your feedback.
Marcelo

> 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
[quoted text clipped - 4 lines]
> Thanks for any help on this.
> Tiffany

Reply to this Message