How do I insert an Auto Date in Excel

R

R. Chambers

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
 
P

Paul B

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
 
C

Coltsfan

=today()

The above formula will give you the date. Just put it where ever yo
want on your sheet.

Best of luc
 
D

Dave Peterson

Do you mean a cell on a worksheet that looks like a form?

If yes, just put
=today()
in your cell and format it the way you like.
 
Top