Your could put =TODAY() in a cell and it will update everyday, if you want
to put in a date that want change you can use a macro with some code like
this, maybe in the open or before print event
Sheets("Sheet1").Range("A1") = Date

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"R. Chambers" <R. wrote in message
...
I would like to insert an auto date in a form and not in the
header/footer.
Is this possible to do and if so, could you please provide me with
instructions