automatically input date?

[djarcadian]

How can I automatically input the days date in a cell?

[Chip Pearson]

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"
<[email protected]> wrote
in message
news:[email protected]...
>
> 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]

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" <[email protected]> wrote
in message news:[email protected]...
>
> 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]

Thanks people!