Put this in a cell:

=today()

Give it a nice date format.

Alex01 wrote:

Please can someone tell me how to format a cell to show current date
each time a sheet is opened?

thanks in advance

--
Alex01
------------------------------------------------------------------------
Alex01's Profile: http://www.excelforum.com/member.php...o&userid=26311
View this thread: http://www.excelforum.com/showthread...hreadid=516232

--

Dave Peterson