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? |
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? |
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? |
All times are GMT +1. The time now is 04:19 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com