monday

monday(d: date) 🡒 date, pure function

Returns the first Monday that precedes the date (inclusive).

Example:

show summary "" a1a3 with
  monday(date(2019, 12, 28))
  monday(date(2019, 12, 30))
  monday(date(2020, 1, 1))

See also

• The WEEKDAY function of Excel.