[SOLVED] Fill cell with today's date

[Sarahbkelly]

Is there a way to automatically fill a cell with todays date?

[daddylonglegs]

Use

=TODAY()

[pinmaster]

Hi,

=TODAY()

Regards
JG

"Sarahbkelly" wrote:

> Is there a way to automatically fill a cell with todays date?

[Gord Dibben]

=TODAY()

Note: this will update every new day.

If you want a static date just hit CTRL + ;


Gord Dibben MS Excel MVP

On Thu, 19 Jan 2006 14:40:02 -0800, "Sarahbkelly"
<Sarahbkelly@discussions.microsoft.com> wrote:

>Is there a way to automatically fill a cell with todays date?

[Roger Govier]

Hi Sarah

You have 2 answers giving you =TODAY(), which is quite correct.
Obviously this will change when you open the file tomorrow.
if you just wanted to insert today's date into a cell and have it fixed,
then type Ctrl ; (Control + semicolon)

--
Regards

Roger Govier


"Sarahbkelly" <Sarahbkelly@discussions.microsoft.com> wrote in message
news:C1280798-9D25-47F6-82D2-EA08DED7C3DC@microsoft.com...
> Is there a way to automatically fill a cell with todays date?

[astronautt]

I need to print the timestamp also along with the date

[Roger Govier]

Hi

Then type Ctrl+; then a space then Ctrl +: (Ctrl + semicolon space Ctrl
+ colon)

--
Regards

Roger Govier


"astronautt" <astronautt.21wnfn_1137713100.9047@excelforum-nospam.com>
wrote in message
news:astronautt.21wnfn_1137713100.9047@excelforum-nospam.com...
>
> I need to print the timestamp also along with the date
>
>
> --
> astronautt
> ------------------------------------------------------------------------
> astronautt's Profile:
> http://www.excelforum.com/member.php...o&userid=30652
> View this thread:
> http://www.excelforum.com/showthread...hreadid=503118
>