=Today() Or use =Now() for date and time and format for date
THESE will both show current pc clock settings and updaste with every
calculation cycle

"tbw" wrote:

In Excel, how do i get the spreadsheet to automatically update a cell entry
to today's date? (i.e., if i open the spreadsheet on 10/5/05, a cell is
programmed to show 10/5/05; if i open it on 10/6/05, the cell shows 10/6/05,
etc.).