Thread: Make date change in excel to current date when opening daily?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Max
 
Posts: n/a
Default Make date change in excel to current date when opening daily?
"jamie" wrote:
Can someone please tell me how to set a default in excel
to make the date current evey time i open a file.

Use the TODAY() function
Eg: in A1: =TODAY()
A1 will always return the current date
(calc mode assumed set to auto, of course)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---


Reply With QuoteReply With Quote