To automatically update the date in Excel, you can use the TODAY function. Insert the following formula in the cell where you want the date:
=TODAY()
This cell will now display the current date, and it will automatically update every time you open or recalculate the spreadsheet.