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.

 

[Gary''s Student]

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

 

[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..