automatic "date update"
 

How can i set up an automatic "date update" in excel? In other words, I would
like excel to update this cell with the current date automatically every day
without me have to open the file or anything.

automatic "date update"
 

hi
enter it as a formula.
=today() 'date only
or
=now() 'date+time

regards
FSt1

"hvygns15" wrote:

How can i set up an automatic "date update" in excel? In other words, I would
like excel to update this cell with the current date automatically every day
without me have to open the file or anything.

automatic "date update"
 

Great! Thanks. Will it continually update without me opening it or will I
have to open the page in order for the "auto update" to work? The reason I am
asking is that I am looking to tie an alert to it and will not always be
opening the page.

"FSt1" wrote:

hi
enter it as a formula.
=today() 'date only
or
=now() 'date+time

regards
FSt1

"hvygns15" wrote:

How can i set up an automatic "date update" in excel? In other words, I would
like excel to update this cell with the current date automatically every day
without me have to open the file or anything.

automatic "date update"
 

hi
no. sorry. i guess i misunderstood. the sheet must calculate for the formula
to update.

regards
FSt1

"hvygns15" wrote:

Great! Thanks. Will it continually update without me opening it or will I
have to open the page in order for the "auto update" to work? The reason I am
asking is that I am looking to tie an alert to it and will not always be
opening the page.

"FSt1" wrote:

hi
enter it as a formula.
=today() 'date only
or
=now() 'date+time

regards
FSt1

"hvygns15" wrote:

How can i set up an automatic "date update" in excel? In other words, I would
like excel to update this cell with the current date automatically every day
without me have to open the file or anything.