"Now" Function

[Kenneth]

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

 

[Pete_UK]

Don't use the NOW (or TODAY) function, as this will always
recalculate.

You can fix the values of those formulae to stop them changing.

You can use CTRL with : (colon) to get a date-stamp, and/or CTRL
with ; (semicolon) to get a time-stamp.

Hope this helps.

Pete

 

[Max]

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

You can't use formulas as the "date/time stamps" as these will recalc

Try JE McGimpsey's coverage of "Time and date stamps" at his page:
http://www.mcgimpsey.com/excel/timestamp.html
Scroll down to the part: Using a worksheet event macro
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,000 Files:370 Subscribers:66
xdemechanik
---

 

[Shane Devenshire]

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+:

 

[Curt]

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

 

[Dave P]

=DAY(TODAY())=15
Will return TRUE only on the 15th of any month of any year

 

[Michael.Tarnowski]

=DAY(TODAY())=15
Will return TRUE only on the 15th of any month of any year

To implement a correct time-stamp mechanism it is sometimes necessary
to "rebuild" the time-stamping formula; have a look at
http://www.excelforum.com/excel-programming/390157-functions-wont-calculate-without-f2.html
Cheers Michael