How do I turn on the automatic date function

[Dave]

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

 

[John]

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

 

[Jacob Skaria]

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

Format to as required