From ed5640d8b587fbcfed7dd7967f3de04b37a76f26 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sun, 7 Apr 2024 11:06:44 +0200 Subject: Adding upstream version 4:7.4.7. Signed-off-by: Daniel Baumann --- helpcontent2/source/text/scalc/01/func_eomonth.xhp | 49 ++++++++++++++++++++++ 1 file changed, 49 insertions(+) create mode 100644 helpcontent2/source/text/scalc/01/func_eomonth.xhp (limited to 'helpcontent2/source/text/scalc/01/func_eomonth.xhp') diff --git a/helpcontent2/source/text/scalc/01/func_eomonth.xhp b/helpcontent2/source/text/scalc/01/func_eomonth.xhp new file mode 100644 index 000000000..74d3af592 --- /dev/null +++ b/helpcontent2/source/text/scalc/01/func_eomonth.xhp @@ -0,0 +1,49 @@ + + + + + +EOMONTH +/text/scalc/01/func_eomonth.xhp + + + +EOMONTH function + +

EOMONTH +

+Returns the date of the last day of a month which falls months away from the start date. + + +EOMONTH(StartDate; Months) + +StartDate is a date (the starting point of the calculation). + +Months is the number of months before (negative) or after (positive) the start date. + +What is the last day of the month that falls 6 months after September 14 2001? + +=EOMONTH(DATE(2001;9;14);6) returns the serial number 37346. Formatted as a date, this is 2002-03-31. +=EOMONTH("2001-09-14";6) works as well. If you specify the date directly, we recommend using the standard ISO 8601 format because this should be independent of your selected locale settings. +
+ EOMONTH wiki page + +
+ + -- cgit v1.2.3