When open document, want date to be current automatically. How?
 

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.

When open document, want date to be current automatically. How?
 

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.

When open document, want date to be current automatically. How?
 

Are you talking about Excel or Word? In Excel you need either a macro or a
formula


=TODAY()



will return the computer date


In Word it is under insertdate and time and then you need to check "update
automatically"



--
Regards,

Peo Sjoblom



"Rae" wrote in message
...
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.

When open document, want date to be current automatically. Ho
 

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.

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.

When open document, want date to be current automatically. Ho
 

So, it has to be in a cell at the top of each page or can I have this in the
header/footer option?

"David Biddulph" wrote:

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.