| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
enter a current date in a cell?
How can I enter a formula in a cell so that when I click on that cell it will
show today's date or the current date? |
|
#2
|
|||
|
|||
|
You can only get excel to do stuff when you click by using a worksheet
change event. If you want to enter the current time or date quickly, try Ctrl+; or Ctrl+Shift+: -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "Tpeyton77" wrote in message ... How can I enter a formula in a cell so that when I click on that cell it will show today's date or the current date? |
|
#3
|
|||
|
|||
|
Try the Today() function - don't need to enter anything between brackets.
"Tpeyton77" wrote: How can I enter a formula in a cell so that when I click on that cell it will show today's date or the current date? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change cell color dependin on date ... | Excel Worksheet Functions | |||
| Changing Cell formats to date fields automatically | Excel Worksheet Functions | |||
| How do I enter the creation date in Excel, rather than current da. | Excel Worksheet Functions | |||
| date format within a cell containing a formula | Excel Discussion (Misc queries) | |||
| Using formulas to determine date in one cell based on date in anot | Excel Worksheet Functions | |||
Linear Mode
