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
Applying the TODAY function
We can automatically generate the current date for each day by using the TODAY function
- 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.