Date : =today()

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If I use =today() on a work sheet, is it possible to make the date " not
change " the folowing days, Tony
 
Only by making the cell a value.
Type =today() then hit the 'F9' key THEN hit ENTER.
HTH,
 
or Ctrl-; (semi-colon)

--
HTH

Bob Phillips

Gary L Brown said:
Only by making the cell a value.
Type =today() then hit the 'F9' key THEN hit ENTER.
HTH,
--
Gary Brown
gary_brown@ge_NOSPAM.com
If this post was helpful, please click the ''''''''Yes'''''''' button next
to ''''''''''''''''Was this Post Helpfull to you?".
Click to expand...
 
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
 
control-semicolon
will put the current date in the cell--and it won't change.
 
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

Excel Message box with days of month & date. 1
Count if cell value 2
Excel VBA to go to specific sheet & cell in the current workbook not working. 2
Excel Colour code dates 1
Conditionally Format Particular Dates 1
Conditional formatting dates 3
Excel Date Count 2
Excel How to get the number of days an item was opened from the today's date. 14

Back
Top