How To Have Excel Automatically Update Date

If you are an avid Excel user, you know how challenging it can be to keep track of the date, especially when working with lots of data. But did you know that Excel can automatically update the date for you? This feature is incredibly helpful and can save you a great deal of time. By the end of this blog post, you’ll be able to use Excel to auto-update dates whenever necessary.

Using the TODAY Function

The easiest way to have Excel automatically update the date is to use the TODAY function. This built-in function returns the current date in a day/month/year format. Every time you open your workbook, Excel will automatically update the date.

To use the TODAY function, simply type it into a cell:


The cell will immediately display the current date. Whenever you reopen the file on a future date, Excel will update the cell with the new date.

Using the NOW Function

If you also want to include the current time, you can use the NOW function. This is very similar to the TODAY function, but it also includes the current time.

Just type the following command into a cell:


Again, Excel will automatically update this cell whenever you reopen the file.


Excel has proven to be a very versatile tool that can save us time by automatically updating dates. By using the TODAY or NOW functions, you can keep your worksheets up-to-date without any manual effort. Remember, knowledge is power. Keep learning and exploring the features of Excel!