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()