Show current date in cell

[Alex01]

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

thanks in advance

[Dave Peterson]

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

[Gary''s Student]

In an un-used cell format as General and then enter:
=TODAY()
--
Gary's Student


"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
>
>

[Alex01]

thank for your replies.

sorry i've started another thread. Is it possible to do this with date and time please?


alex

[anu_manu]

TRY THIS

=now()

this gives present date and time..