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