Can Excel automatically enter the current date in a spreadsheet?
 

I know Excell can auto enter the current date in a footer or header. However
i need it in my spreadsheet. Is there any way to insert it automatically?

Can Excel automatically enter the current date in a spreadsheet?
 

=TODAY()

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Donna" wrote in message ...
|I know Excell can auto enter the current date in a footer or header. However
| i need it in my spreadsheet. Is there any way to insert it automatically?

Can Excel automatically enter the current date in a spreadsheet?
 

Donna Wrote:
I know Excell can auto enter the current date in a footer or header.
However
i need it in my spreadsheet. Is there any way to insert it
automatically?
Hi Donna,

try this

=TODAY()

or

=NOW() this will display date and time

oldchippy :)


--
oldchippy
------------------------------------------------------------------------
oldchippy's Profile: http://www.excelforum.com/member.php...o&userid=19907
View this thread: http://www.excelforum.com/showthread...hreadid=568074

Can Excel automatically enter the current date in a spreadsheet?
 

Use the today() function and format the cell to display as a date

Note: this will update every time you recalculate the sheet. If you want a
static date, select the cell where you want it to display and press Ctrl-;
(control and semicolon)


"Donna" wrote:

I know Excell can auto enter the current date in a footer or header. However
i need it in my spreadsheet. Is there any way to insert it automatically?