View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JP Ronse JP Ronse is offline
external usenet poster
 
Posts: 174
Default what is the difference between Now() and Today()

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