Differences

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

--- syntax:functions:monthend [2018/08/13 16:12] – created dmitry
+++ syntax:functions:monthend [2021/09/10 22:27] (current) – craigt
@@ Line 1: / Line 1: @@
-===== MonthEnd(date_as_number) =====
+====== MonthEnd(date) ======
+Category:  Date and Time function
-Returns the last day of the month of the date.
+\\
+=====Description=====
+This function returns the date serial number of the last day of the month //date// falls in.
+\\
+=====Arguments=====
+^Argument^Type^Description^
+|date|Date or Number (date serial)|An expression representing a date to derive the month's last day 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=====
+  monthend(#2018-06-06)  //Returns 43281 (Equivalent to June 30th, 2018.)
+  monthend(#2020-02-15)  //Returns 43890 (Equivalent to February 29th, 2020 - a leap year.)
+  day( monthend( #2019-01-10 ) )  //Returns 31 (Combined with the Day function, only the day number is returned.)
+\\
+=====See also=====
+  * [[syntax:functions:month|Month(date_as_number)]]
+  * [[syntax:functions:monthname|MonthName(month_num)]]
+  * [[syntax:functions:monthnamelocal|MonthNameLocal(month_num)]]
+  * [[syntax:functions:monthstart|MonthStart(date)]]
-^  Example  ^  Result  ^ Notes ^
-| monthend(#2018-06-06)  |  43281 |Equivalent to June June 30th, 2018  |