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