how can i set up an automatic "date update" in excel?
 

In other words, i would like excel to update this cell with the current date
every time when i open the document. Can i do that?

Answer: how can i set up an automatic "date update" in excel?
 

Automatic Date Update in Excel

1. Select the cell where you want the date to appear.

1. Go to the "Formulas" tab in the ribbon at the top of the Excel window.
2. Click on the "Insert Function" button and search for the
   Formula:

   ---

   =TODAY() 


   ---

   function.
3. Select the
   Formula:

   ---

   =TODAY() 


   ---

   function and click "OK".
4. The
   Formula:

   ---

   =TODAY() 


   ---

   function will now appear in the formula bar at the top of the Excel window.
5. Press the "Enter" key to insert the current date into the selected cell.

2. Save the Excel document.
3. Close the Excel document.
4. Reopen the Excel document.
5. The date in the selected cell should now be updated to the current date.

That's it! Now every time you open the Excel document, the date in the selected cell will automatically update to the current date.

one way:

=TODAY()

In article ,
"Litzyam" wrote:

In other words, i would like excel to update this cell with the current date
every time when i open the document. Can i do that?

One way
=today()
HTH

"Litzyam" wrote:

In other words, i would like excel to update this cell with the current date
every time when i open the document. Can i do that?