Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"Now" Function
How do you keep the "now" function from updating the date when you open the
spreadsheet at a later date? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"Now" Function
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 On Jan 4, 10:32*pm, Kenneth wrote: How do you keep the "now" function from updating the date when you open the spreadsheet at a later date? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"Now" Function
"Kenneth" wrote:
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 --- |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"Now" Function
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? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"Now" Function
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? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"Now" Function
=DAY(TODAY())=15
Will return TRUE only on the 15th of any month of any year "Curt" wrote in message ... 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? |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"Now" Function
On Mar 7, 8:36 pm, "Dave P"
wrote: =DAY(TODAY())=15 Will return TRUE only on the 15th of any month of any year "Curt" wrote in message ... 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? 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-prog...ithout-f2.html Cheers Michael |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text "comparison" operator for "contains" used in an "IF" Function | Excel Worksheet Functions | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel |