Automatic Date Insertion?
 

Hello,

I was curious if there was a macro or some function I could enter in a
paticular cell of a reusable workbook that would automatically enter
the Date with Day in the cell when the workbook is opened? If so, how
would I implement this?

Thank You Very Much!


--
tristatefab
------------------------------------------------------------------------
tristatefab's Profile: http://www.excelforum.com/member.php...o&userid=32647
View this thread: http://www.excelforum.com/showthread...hreadid=524549

Automatic Date Insertion?
 

In the cell of your choice enter =NOW() and format it as a date however
you choose.


--
intruder9
------------------------------------------------------------------------
intruder9's Profile: http://www.excelforum.com/member.php...o&userid=30107
View this thread: http://www.excelforum.com/showthread...hreadid=524549

Automatic Date Insertion?
 

Do you know about =TODAY() ?

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"tristatefab"
wrote in message
...

Hello,

I was curious if there was a macro or some function I could enter in a
paticular cell of a reusable workbook that would automatically enter
the Date with Day in the cell when the workbook is opened? If so, how
would I implement this?

Thank You Very Much!


--
tristatefab
------------------------------------------------------------------------
tristatefab's Profile:
http://www.excelforum.com/member.php...o&userid=32647
View this thread: http://www.excelforum.com/showthread...hreadid=524549