Differences

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

--- syntax:functions:weekend [2018/08/13 16:32] – dmitry
+++ syntax:functions:weekend [2021/09/09 16:39] (current) – [Examples] craigt
@@ Line 1: / Line 1: @@
-===== WeekEnd(date_as_number) =====
+====== WeekEnd(date) ======
+Category:  Date and Time function
-Returns the last day (Saturday) of the week of the date.
+\\
+=====Description=====
+This function returns the date serial number of the last day (Saturday) of the week //date// falls in.
+\\
+=====Arguments=====
+^Argument^Type^Description^
+|date|Date or Number (date serial)|An expression representing a date to derive the Saturday 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=====
+  weekend(#2018-06-06)  //Returns 43260 (Equivalent to Sat, June 9th, 2018.)
+  weekend(30970)  //Returns 30975 (Equivalent to Sat, October 20th, 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:weekstart|WeekStart(date)]]
-^  Example  ^  Result  ^ Notes ^
-| weekstart(#2018-06-06)  |  43260   |Equivalent to Saturday, June 9th, 2018.  |