today's date static

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
 
J

joeu2004

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.
 

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

Need to auto-enter last updated date, only if another cell has changed 1
Autofill today's date Everyday 2
How to copy one column values to another column based on conditionthat row2 contain todays date 4
Today's date 1
Today's Date 1
Convert a yyyymmdd date format in code 4
Date Formula 3
Today only 4

Top