TODAY Formula

If you have to change the date every day just because of that dynamic formula which needs current date every time, then the Excel’s TODAY formula will help you in this situation. This formula will update the date dynamically every-day.

Previously In Excel Formulas; How to use TEXTJOIN Formula in Excel?

Following are the steps to follow:

STEP1. In the first step you have to enter the TODAY function in a blank cell to apply the formula e.g.

=TODAY()

TODAY Formula

It’s as simple as that!

NOTE: If you get a wrong date or something, then reset the date of your windows or connect to the internet to do it automatically.