EOMONTH

Returns the date of the last day of a month which falls months away from the start date.

Note Icon

This function is part of the Open Document Format for Office Applications (OpenDocument) standard Version 1.2. (ISO/IEC 26300:2-2015)


Syntax

EOMONTH(Počiatočný dátum; Mesiace)

Počiatočný dátum je dátum, od ktorého sa odvíja výpočet.

Mesiace je počet mesiacov pred (záporné číslo) alebo po (kladné číslo) počiatočnom dátume.

Example

Aký bol posledný deň mesiaca, ktorý bol šesť mesiacov po 14. Septembri 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 the date is given as string, it has to be in ISO format.

Date & Time Functions

DATE

[text/scalc/01/func_datedif.xhp#datedif not found].

DATEVALUE

DAY

DAYS

DAYS360

EASTERSUNDAY

EDATE

EOMONTH

HOUR

[text/scalc/01/func_isoweeknum.xhp#isoweeknum not found].

MINUTE

MONTH

NETWORKDAYS

NETWORKDAYS.INTL

NOW

SECOND

TIME

TIMEVALUE

TODAY

WEEKDAY

WEEKNUM

WEEKNUM_ADD

[text/scalc/01/func_weeknum_ooo.xhp#weeknum_ooo not found].

WORKDAY

WORKDAY.INTL

YEAR

YEARFRAC

Please support us!