How do I turn on the automatic date function
 

I want excel to automatically add the current date in a cell.

How do I turn on the automatic date function
 

Hi Dave
Type in the cell you want =TODAY() and format the way you like DD/MM/YY
That will change automatic everyday.
HTH
John
"Dave" wrote in message
...
I want excel to automatically add the current date in a cell.

How do I turn on the automatic date function
 

=TODAY()
--
David Biddulph

Dave wrote:
I want excel to automatically add the current date in a cell.

How do I turn on the automatic date function
 

=TODAY() for date
=NOW() for date and time

Format to as required
--
If this post helps click Yes
---------------
Jacob Skaria


"Dave" wrote:

I want excel to automatically add the current date in a cell.