is there a way to use only date for a trigger. What I am trying to do is have
an event happen on the 15th of each month. regardless of year etc.
Thanks for any input I am going nuts
Appreciate help

"Shane Devenshire" wrote:

Hi,

the whole point of =NOW() and =TODAY() is to provide a date that always
updates. If you suppress the calculation of the spreadsheet these functions
will not update, but neither will anything else.

If you want a date that doesn't update just type it in - 1/22/2009 for
example, or use the shortcuts suggest by Pete which input the Current date or
Current time as indicated by the computer's clock and calendar.

To enter the date and time as hard coded equivalent of NOW in one cell -
press Ctrl+; space Ctrl+:


--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Kenneth" wrote:

How do you keep the "now" function from updating the date when you open the
spreadsheet at a later date?