| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Date : =today()
If I use =today() on a work sheet, is it possible to make the date " not
change " the folowing days, Tony |
|
#2
|
|||
|
|||
|
Only by making the cell a value.
Type =today() then hit the 'F9' key THEN hit ENTER. HTH, -- Gary Brown If this post was helpful, please click the ''''''''Yes'''''''' button next to ''''''''''''''''Was this Post Helpfull to you?". "Tony Guzzo" wrote: If I use =today() on a work sheet, is it possible to make the date " not change " the folowing days, Tony |
|
#3
|
|||
|
|||
|
or Ctrl-; (semi-colon)
-- HTH Bob Phillips "Gary L Brown" wrote in message ... Only by making the cell a value. Type =today() then hit the 'F9' key THEN hit ENTER. HTH, -- Gary Brown If this post was helpful, please click the ''''''''Yes'''''''' button next to ''''''''''''''''Was this Post Helpfull to you?". "Tony Guzzo" wrote: If I use =today() on a work sheet, is it possible to make the date " not change " the folowing days, Tony |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date : =today(), keep actual date, don't change the next day
I've been scanning past posts to find the answer to my questions and I found
this, my question is how do I preserve my today date with code so it does not change tomorrow. Thanks "Bob Phillips" wrote: or Ctrl-; (semi-colon) -- HTH Bob Phillips "Gary L Brown" wrote in message ... Only by making the cell a value. Type =today() then hit the 'F9' key THEN hit ENTER. HTH, -- Gary Brown If this post was helpful, please click the ''''''''Yes'''''''' button next to ''''''''''''''''Was this Post Helpfull to you?". "Tony Guzzo" wrote: If I use =today() on a work sheet, is it possible to make the date " not change " the folowing days, Tony |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date : =today(), keep actual date, don't change the next day
control-semicolon
will put the current date in the cell--and it won't change. SITCFanTN wrote: I've been scanning past posts to find the answer to my questions and I found this, my question is how do I preserve my today date with code so it does not change tomorrow. Thanks "Bob Phillips" wrote: or Ctrl-; (semi-colon) -- HTH Bob Phillips "Gary L Brown" wrote in message ... Only by making the cell a value. Type =today() then hit the 'F9' key THEN hit ENTER. HTH, -- Gary Brown If this post was helpful, please click the ''''''''Yes'''''''' button next to ''''''''''''''''Was this Post Helpfull to you?". "Tony Guzzo" wrote: If I use =today() on a work sheet, is it possible to make the date " not change " the folowing days, Tony -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
| Recurring annual events using a specific date as a trigger date | Excel Worksheet Functions | |||
| date and time | New Users to Excel | |||
| Using formulas to determine date in one cell based on date in anot | Excel Worksheet Functions | |||
| How do you keep the date using =TODAY() from changing? | Excel Worksheet Functions | |||
Linear Mode
