Let's say you need Excel to display today's current date every time you open the file. In this case, you can use the formula TODAY() .
But there is an easier way to do it. You can use a keyboard shortcut
The difference between these two approaches will be only in the later displayed dates. Function TODAY() changes the actual date every day. If you use hotkeys
So use a method that depends on your goals.