automatic "date update"

H

hvygns15

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

hvygns15

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

FSt1

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

regards
FSt1
 
Top