[SOLVED] how can i set up an automatic "date update" in excel?

Litzyam · 09-13-2005, 11:05 AM

In other words, i would like excel to update this cell with the current date
every time when i open the document. Can i do that?

JE McGimpsey · 09-13-2005, 11:05 AM

one way:

=TODAY()

In article <D8818AFF-8489-4FF1-B94D-A08FB0B45F01@microsoft.com>,
"Litzyam" <Litzyam@discussions.microsoft.com> wrote:

> In other words, i would like excel to update this cell with the current date
> every time when i open the document. Can i do that?

Ray A · 09-13-2005, 12:05 PM

One way
=today()
HTH

"Litzyam" wrote:

> In other words, i would like excel to update this cell with the current date
> every time when i open the document. Can i do that?

Thread: [SOLVED] how can i set up an automatic "date update" in excel?

Thread Tools

Display