today's date static

  • Thread starter Thread starter mp
  • Start date Start date
M

mp

Is this the correct formula to have today's date put in a cell
and have it not change tomorrow when you open the spreadsheet?
=VALUE(TODAY())

meaning i could each day copy that down one cell to "date"
todays entries..

in other words, I want an easier way to put today's date in a cell
compared to entering by hand
however Today() will update the next time the ss is opened wont' it?
thanks
mark
 
I want an easier way to put today's date in a cell
compared to entering by hand
Click to expand...

Use the keyboard shortcut ctrl+; -- that is, press and hold Ctrl while
you press semicolon.
 
Back
Top