today's date static
 

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

today's date static
 

On Jan 30, 11:27*am, "mp" wrote:
I want an easier way to put today's date in a cell
compared to entering by hand

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