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

Did this answer your question?