Rješavač

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(Start_date; Months)

Start_date je datum (pocetna tacka racunice).

Months is the number of months before (negative) or after (positive) the start date.

Example

Koji je zadnji dan mjeseca koji je 6 mjeseci poslije 14. septembra 2001.?

=EOMONTH("14/09/2001"; 6) vraca 31/03/2002.

=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

[text/scalc/01/func_date.xhp#date not found].

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

[text/scalc/01/func_datevalue.xhp#datevalue not found].

[text/scalc/01/func_day.xhp#day not found].

[text/scalc/01/func_days.xhp#days not found].

[text/scalc/01/func_days360.xhp#days360 not found].

[text/scalc/01/func_eastersunday.xhp#eastersunday not found].

[text/scalc/01/func_edate.xhp#edate not found].

[text/scalc/01/func_eomonth.xhp#eomonth not found].

[text/scalc/01/func_hour.xhp#hour not found].

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

[text/scalc/01/func_minute.xhp#minute not found].

[text/scalc/01/func_month.xhp#month not found].

NETWORKDAYS

NETWORKDAYS.INTL

[text/scalc/01/func_now.xhp#now not found].

[text/scalc/01/func_second.xhp#second not found].

[text/scalc/01/func_time.xhp#time not found].

[text/scalc/01/func_timevalue.xhp#timevalue not found].

[text/scalc/01/func_today.xhp#today not found].

WEEKDAY

[text/scalc/01/func_weeknum.xhp#weeknum not found].

[text/scalc/01/func_weeknumadd.xhp#weeknumadd not found].

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

[text/scalc/01/func_workday.xhp#workday not found].

WORKDAY.INTL

[text/scalc/01/func_year.xhp#year not found].

[text/scalc/01/func_yearfrac.xhp#yearfrac not found].

Please support us!