Excel: Today Function

In Excel, the Today function returns the current system date. This function will refresh the date whenever the worksheet recalculates.

The syntax for the Today function is:

Today()

Applies To:

• Excel 2007, Excel 2003, Excel XP, Excel 2000

For example:

Let's take a look at an example:

The spreadsheet will continue to display this value, until the worksheet recalculates. By pressing the F9 key, you can force the worksheet to recalculate and the TODAY function will update its value.