Make date change in excel to current date when opening daily?

J

jamie

Can someone please tell me how to set a default in excel to make the date
current evey time i open a file.
 
C

CLR

=TODAY() typed in any cell will return the current date. If the file is
saved and re-opened tomorrow, it will show tomorrow's date.......

hth
Vaya con Dios,
Chuck, CABGx3
 
M

Max

jamie said:
Can someone please tell me how to set a default in excel
to make the date current evey time i open a file.
Click to expand...

Use the TODAY() function
Eg: in A1: =TODAY()
A1 will always return the current date
(calc mode assumed set to auto, of course)
 
Top