Examples
(TODAY() - 1) gives yesterday's date.
(TODAY() + 1) gives tomorrow's date.
(TODAY() + 7) gives the date one week from today.
(TODAY() - WEEKDAY(TODAY())) gives the date of Saturday of last week. See also: WEEKDAY().
(TODAY() - WEEKDAY(TODAY()) + 4) gives the date of Wednesday of this week.
Syntax
TODAY()
Return Value
A Date value: the current date.
See Also
DAY(), EOMONTH(), MONTH(), NOW(), WEEKDAY(), WEEKNUM(), YEAR()