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

Hi,

=TODAY()

Regards
JG

"Sarahbkelly" wrote:

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

Use

=TODAY()


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=503118

=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"
wrote:

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

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" wrote in message
...
Is there a way to automatically fill a cell with todays date?

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

Hi

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

--
Regards

Roger Govier


"astronautt"
wrote in message
...

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