"Now" Function

  • Thread starter Thread starter Kenneth
  • Start date Start date
K

Kenneth

How do you keep the "now" function from updating the date when you open the
spreadsheet at a later date?
 
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
 
Kenneth said:
How do you keep the "now" function from updating the date
when you open the spreadsheet at a later date?
Click to expand...

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
---
 
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+:
 
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
 
=DAY(TODAY())=15
Will return TRUE only on the 15th of any month of any year
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

want to track time while paste value in multiple column of same roe 1
Excel PRICE function: How does it compute Issue Date of the Security 5
NOW() function that won't change 4
Saving TODAY function to keep the date accurate. (when it was done) 2
changing cell background colors with formulas 5
Sumif Question 1
Dsum Help 0
Difference between NOW() and TODAY() 9

Back
Top