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:

=TODAY()

  • 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.

Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California

Leave a Comment

avatar