View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Chip Pearson
 
Posts: n/a
Default 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