If you put =TODAY() in a cell, then whenever you open the spreadsheet, the
date will appear in that cell and be updated.
--
David Biddulph

"amir" wrote in message
...
yes, but i have to type that code every time i open excel.What i really
want
to know is there a way that, once i set the date it has to update
automaticaly and appear in a cell when i open excel.

"David Biddulph" wrote:

=TODAY()
--
David Biddulph

"amir" wrote in message
...
i want the date to appear Automaticaly,in a cell when i open excel

"Gordon" wrote:

"amir" wrote in message
...
how to set the date to appear Automaticaly, when i open excel


Appear WHERE?