Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I insert an Auto Date in Excel
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
=today() The above formula will give you the date. Just put it where ever you want on your sheet. Best of luck -- Coltsfan ------------------------------------------------------------------------ Coltsfan's Profile: http://www.excelforum.com/member.php...o&userid=19982 View this thread: http://www.excelforum.com/showthread...hreadid=475618 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
format date in excel | Excel Discussion (Misc queries) | |||
How do I insert a date created in a cell in excel? | Excel Worksheet Functions | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
how do i set an auto date function in excel or word? | Excel Discussion (Misc queries) | |||
Auto date changing in Excel is maddening | Charts and Charting in Excel |