TODAY( )

The TODAY function returns today's date. It actually calculates a date code for the current day and, by default, this is then formatted and displayed as a recognizable date.

For example, the formula

TODAY()

returns "July/2/1997" on that date.

The date is taken directly from the operating system (e.g. Windows 98) - if it appears incorrect, you need to adjust the clock on your PC.

See also:

Other date functions