Fill cell with today's date

[Sarahbkelly]

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

 

[pinmaster]

Hi,

=TODAY()

Regards
JG

 

[daddylonglegs]

Use

=TODAY(

 

[Gord Dibben]

=TODAY()

Note: this will update every new day.

If you want a static date just hit CTRL + ;


Gord Dibben MS Excel MVP

 

[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)

 

[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]...