View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson
 
Posts: n/a
Default How to automatically update the date any time the Excel is openned

You could use:
=today()

If you need date and time, you could use:
=now()
(format it nicely)

DORI wrote:

I have a worksheet with a certain cell dedicated for today's date. Is it
possible to programm that cell so that any time I open the file, it
automatically reflects the today's date?
Thanks,
Dori


--

Dave Peterson