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