Both seem to change when you reopen the spreadsheet. I'd like the date I
create the worksheet to be saved and not updated everytime I reopen it. Any
ideas?

Difference between Now() and Today() functions in Excel

The Today() function returns only the current date, without the time.

The Now() function returns both the current date and time.

Workaround to insert current date as a static value

Instead of using the Now() or Today() function, you can use the keyboard shortcut "Ctrl + ;" to insert the current date in a cell.

Here are the steps to insert the current date using the keyboard shortcut:

1. Select the cell where you want to insert the date.
2. Press "Ctrl + ;" on your keyboard.
3. The current date will be inserted in the selected cell as a static value.

Mary,

Today() is today's date
Now() is literally that the date and time NOW

Both will update so to get a static date try

CTRL + ;

Mike

"Mary" wrote:

Both seem to change when you reopen the spreadsheet. I'd like the date I
create the worksheet to be saved and not updated everytime I reopen it. Any
ideas?

Now() includes the time as well as the date.

You would need to remove the formula to do that, and replace with the value.

Try Ctrl-; (semi-colon) in the cell.

--
__________________________________
HTH

Bob

"Mary" wrote in message
...
Both seem to change when you reopen the spreadsheet. I'd like the date I
create the worksheet to be saved and not updated everytime I reopen it.
Any
ideas?

And just to add the frosting...

ctrl-:
will show just the time.

Mary wrote:

Both seem to change when you reopen the spreadsheet. I'd like the date I
create the worksheet to be saved and not updated everytime I reopen it. Any
ideas?

--

Dave Peterson

On Jul 29, 8:01 pm, Mary wrote:
Both seem to change when you reopen the spreadsheet. I'd like the date I
create the worksheet to be saved and not updated everytime I reopen it. Any
ideas?

Hi Mary,
some difference issues between NOW() and TODAY() is described in
http://groups.google.com/group/micro...a7470455227caa

Have fun
Michael

Hi Marie,

As the functions say today() =date, now() is timestamp including time on
date.

Wkr,

JP


"Michael.Tarnowski" wrote in message
...
On Jul 29, 8:01 pm, Mary wrote:
Both seem to change when you reopen the spreadsheet. I'd like the date I
create the worksheet to be saved and not updated everytime I reopen it.
Any
ideas?

Hi Mary,
some difference issues between NOW() and TODAY() is described in
http://groups.google.com/group/micro...a7470455227caa

Have fun
Michael