Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Date Cell
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 ----------------------:) -- Boethius1 ------------------------------------------------------------------------ Boethius1's Profile: http://www.excelforum.com/member.php...o&userid=30497 View this thread: http://www.excelforum.com/showthread...hreadid=503529 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Date Cell
The TODAY() and NOW() functions will do this. They will update whenever the
spreadsheet is recalculated. You can change the cell format to fit your needs. But, if you open the file at 11:59pm and change a cell 2 minutes later, the date will change. I don't know if that is what you have in mind or not. HTH, Elkar "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 ----------------------:) -- Boethius1 ------------------------------------------------------------------------ Boethius1's Profile: http://www.excelforum.com/member.php...o&userid=30497 View this thread: http://www.excelforum.com/showthread...hreadid=503529 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Date Cell
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 ----------------------:) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
if data in one cell, then date in adjacent cell | Excel Worksheet Functions | |||
Change cell to red when date in other cell is red | Excel Discussion (Misc queries) | |||
SQL - Auto Refresh Upon Cell Value Change | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions | |||
Extract date from cell | Excel Worksheet Functions |