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
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
=today()
The above formula will give you the date. Just put it where ever you want on your sheet.
Best of luck
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. [email protected]> wrote in message
news:[email protected]...
> 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
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.
R. Chambers wrote:
>
> 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
--
Dave Peterson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks