====== WeekStart(date) ====== Category: Date and Time function \\ =====Description===== This function returns the date serial number of the first day (Sunday) of the week //date// falls in. \\ =====Arguments===== ^Argument^Type^Description^ |date|Date or Number (date serial)|An expression representing a date to derive the Sunday date value from.| **Return value type:** Date serial number \\ =====Remarks===== The //date// argument can take any value or expression that evaluates to a date serial value. Examples include: * A date string: #2019-12-12 * A date serial value: 43811 (the date serial for "2019-12-12") * A date value created using any of the Date/Time functions that returns a date serial value. \\ =====Examples===== weekstart(#2018-06-06) //Returns 43254 (Equivalent to Sun, June 3th, 2018.) weekstart(30970) //Returns 30969 (Equivalent to Sat, October, 14th, 1984.) \\ =====See also===== * [[syntax:functions:isoweeknumber|ISOWeekNumber(date)]] * [[syntax:functions:isweekend|IsWeekend(date)]] * [[syntax:functions:weekday|Weekday(date)]] * [[syntax:functions:weekdayname|WeekDayName(date)]] * [[syntax:functions:weekend|WeekEnd(date)]]