EOWEEK()

Date of last day of a week from Date or DateTime

Date of the last day of a week from Date or DateTime.

Note: AppSheet considers Saturday the last day of the week.

Sample usage

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

(EOWEEK(TODAY()) + 2)  returns the date of Monday of next week.

(EOWEEK(TODAY() + 7)) or (EOWEEK(TODAY()) + 7) returns the date of Saturday of next week.

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

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

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

EOWEEK("2/1/2020") returns 2/1/2020 (from a Date).

Week number

Computes the number of a week within its month.

SWITCH(
  EOWEEK([date]),
  EOWEEK(EOMONTH([date], -1) + 1),
    1,
  EOWEEK(EOMONTH([date], -1) + 1 + 7),
    2,
  EOWEEK(EOMONTH([date], -1) + 1 + 14),
    3,
  EOWEEK(EOMONTH([date], -1) + 1 + 21),
    4,
  5
)

Syntax

EOWEEK(when)

  • when - A Date or DateTime value.

See also

DAY()

EOMONTH()

EWOMONTH()

MONTH()

WORKDAY()

Was this helpful?
How can we improve it?
Search
Clear search
Close search
Google apps
Main menu
Search Help Center
false