formula for current date when opening spread sheet
 

I have gotten "rusty" sence i retired. i want the current date to show in my
spread sheet each time I open it. I am using excell 2000.

formula for current date when opening spread sheet
 

In the thisworkbook module, workbook_open event

sheets("sheet1").range("a1")=date

--
Don Guillett
SalesAid Software

"terryman" wrote in message
...
I have gotten "rusty" sence i retired. i want the current date to show in
my
spread sheet each time I open it. I am using excell 2000.

formula for current date when opening spread sheet
 

In a cell enter =TODAY() and format to the style of date you like.

If you also want the time use =NOW() instead.


Gord Dibben MS Excel MVP

On Sat, 9 Dec 2006 09:16:00 -0800, terryman
wrote:

I have gotten "rusty" sence i retired. i want the current date to show in my
spread sheet each time I open it. I am using excell 2000.