Examples

EOWEEK(TODAY()) : The date of Saturday of this week from a Date. See also TODAY().

(EOWEEK(TODAY()) + 2) : The date of Monday of next week.

(EOWEEK(TODAY() + 7)) or (EOWEEK(TODAY()) + 7) : The date of Saturday of next week.

(EOWEEK(TODAY()) - 7) : The date of Saturday of last week. Equivalent to (TODAY() - WEEKDAY(TODAY())). See also WEEKDAY().

EOWEEK(NOW()) : The date of Saturday of this week from a DateTime. See also NOW().

EOWEEK("3/15/2020 14:00:00") : 3/21/2020 (from a DateTime)

EOWEEK("2/1/2020") : 2/1/2020 (from a Date)

Syntax

EOWEEK( when )

Arguments

  • when (Date or DateTime)

Return Value

Date: The date of the last day of the week specified by when if when is recognized as a Date or DateTime value. AppSheet considers Saturday the last day of the week.

See Also

DAY(), EOMONTH(), MONTH(), WORKDAY()

Did this answer your question?