| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
automatically input date?
How can I automatically input the days date in a cell? -- djarcadian ------------------------------------------------------------------------ djarcadian's Profile: http://www.excelforum.com/member.php...o&userid=15877 View this thread: http://www.excelforum.com/showthread...hreadid=549594 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
automatically input date?
The formula
=TODAY() will return the current date, and will update everytime the workbook is calculated. If you want to insert today's date as a constant value, one the will not change, press CTRL <semicolon . -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "djarcadian" wrote in message ... How can I automatically input the days date in a cell? -- djarcadian ------------------------------------------------------------------------ djarcadian's Profile: http://www.excelforum.com/member.php...o&userid=15877 View this thread: http://www.excelforum.com/showthread...hreadid=549594 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
automatically input date?
Ctrl + ;
if you want to enter the time you would use Ctrl + : + does not mean entering the plus sign it mean you hit Ctrl plus the semicolon you can also use formulas =TODAY() =NOW() the formulas will change, then keyboard shortcuts will not -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com "It is a good thing to follow the first law of holes; if you are in one stop digging." Lord Healey "djarcadian" wrote in message ... How can I automatically input the days date in a cell? -- djarcadian ------------------------------------------------------------------------ djarcadian's Profile: http://www.excelforum.com/member.php...o&userid=15877 View this thread: http://www.excelforum.com/showthread...hreadid=549594 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
automatically input date?
Thanks people! :) -- djarcadian ------------------------------------------------------------------------ djarcadian's Profile: http://www.excelforum.com/member.php...o&userid=15877 View this thread: http://www.excelforum.com/showthread...hreadid=549594 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filter data automatically by input | Excel Worksheet Functions | |||
| Insert date automatically | Excel Discussion (Misc queries) | |||
| How do I automatically calculate YTD numbers by changing a date? | Excel Worksheet Functions | |||
| how do i make a cell date sensitive to execute a formula or input. | Excel Discussion (Misc queries) | |||
| How do I make a cell date specific to input a value on a specific. | Excel Discussion (Misc queries) | |||
Linear Mode
