View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default When open document, want date to be current automatically. Ho

You put it in whichever cell you want to show the date.
And it's =NOW() if you want the cell to contain date and time, or =TODAY()
if you just want the date.
--
David Biddulph

"Rae" wrote in message
...
Thank you, Bob I. Where do I enter that in my spreadsheet?

"Bob I" wrote:

In Excel it is "=NOW()"

Rae wrote:

I want the date to show current date automatically when the document is
opened. I have a document in Word that does this but I do not know how
it
was done.