Differences

This shows you the differences between two versions of the page.

--- syntax:functions:weekstart [2018/08/13 16:31] – dmitry
+++ syntax:functions:weekstart [2021/09/09 16:38] (current) – craigt
@@ Line 1: / Line 1: @@
-===== WeekStart(date_as_number) =====
+====== WeekStart(date) ======
+Category:  Date and Time function
-Returns the first day (Sunday) of the week of the date.
+\\
+=====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)]]
-^  Example  ^  Result  ^ Notes ^
-| weekstart(#2018-06-06)  |  43254  |Equivalent to Sunday, June 3rd, 2018.  |