In a cell enter =TODAY() which will update each new day the workbook is
opened.

If you just need a static date, select a cell and hit CTRL + semi-colon(;)


Gord Dibben MS Excel MVP

On Fri, 20 Jan 2006 16:17:49 -0600, Boethius1
wrote:


Hi all,
is there a way when opening a file an elected cell will automatically
enter the date? Have tried using help but can't get it to give me an
answer.
Thanks

----------------------:)