ExcelBanter - automatically input date?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - automatically input date? (https://www.excelbanter.com/excel-discussion-misc-queries/92658-automatically-input-date.html)

djarcadian

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

Chip Pearson

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

Peo Sjoblom

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

djarcadian

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

All times are GMT +1. The time now is 02:19 PM.