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.
|