САНА

Санаи рӯзи охирони моҳро, ки баМоҳҳо дур аст аз Санаи аввал ҳисоб мекунад.

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

Синтаксис

EOMONTH(StartDate; Months)

Start date:аз имрӯз сар карда.

Months: шумораи моҳҳо пеш (манфӣ) ё пас (мусбат).

Намунаҳо

Санаи охирони моҳ, ки ба 6 моҳ пас аз 14 Сентябри 2001?

=EOMONTH("9.14.2001";6) натиҷа 3.31.2002.

=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.

Date & Time Functions

САНА

[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].

DAYSINMONTH

DAYSINYEAR

[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].

ISLEAPYEAR

[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].

MONTHS

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].

WEEKS

WEEKSINYEAR

[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].

YEARS