monday

monday, function

def const pure monday(d: date): date

Returns the first Monday preceding the input date (inclusive).

• d: The input date for which to compute the preceding Monday. If d is a Monday, returns d; otherwise, returns the most recent Monday before d.

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.