Explanation

The TODAY function takes no arguments; it is entered with empty parentheses.

When you enter the TODAY function in a cell, it will display the current date.

Each time the worksheet is recalculated or opened, the date will be updated.

Excel TODAY function

The TODAY function only inserts the date, time is not included.

If you oughta display the current date and time, use the NOW function.

The TODAY function takes no arguments.

you might format the value returned by TODAY with a datenumber format.

If you need current date and time, use…