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: