Go Back

How to Get a Date to Automatically Update in Excel

It is very simple to automatically generate a new date value each day. By using the TODAY function, Excel users of all levels will be able to automatically reference the current date each day after reviewing this tutorial

Final Formula: TODAY()

Applying the TODAY function

We can automatically generate the current date for each day by using the TODAY function

TODAY Syntax:


  • In cell B2, enter this formula =TODAY()

Figure 1 – Applying TODAY formula

We can see in this Example, the formula in B2 returns today’s date. Tomorrow, the formula will automatically update to tomorrow’s date. Be sure to set the formula calculation options to automatic

Instant Connection to an Expert through our Excelchat Service:

Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.

Did this post not answer your question? Get a solution from connecting with the expert.

Another blog reader asked this question today on Excelchat:
Here are some problems that our users have asked and received explanations on

I need to calculate year to date, month to date and quarter to date return for s&p 500 in excel, and i want a interactive table which can update automatically if I change the date.
Solved by C. C. in 27 mins
I need to get excel to automatically update my timezone values based on if DST is applicable within my dates provided
Solved by B. A. in 24 mins
Issues with creating a "top" section that will automatically update as records change. Succesful with one section, but cannot get the 2nd to recognize the categories
Solved by S. H. in 27 mins

Leave a Comment