EOMONTH

āĻŽāĻžāϏ⧇āϰ āĻļ⧇āώ āĻĻāĻŋāύ⧇āϰ āϤāĻžāϰāĻŋāĻ– āĻĒā§āϰāĻĻāĻžāύ āĻ•āϰ⧇ āϝāĻž āĻļ⧁āϰ⧁āϰ āϤāĻžāϰāĻŋāĻ– āĻšāϤ⧇ āĻĻā§‚āϰāĻŦāĻ°ā§āϤāĻŋ āĻŽāĻžāϏ āĻ āĻĒāĻĄāĻŧ⧇āĨ¤

note

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


āϏāĻŋāύāĻŸā§āϝāĻžāĻ•ā§āϏ

EOMONTH(āĻļ⧁āϰāϰ āϤāĻžāϰāĻŋāĻ–; āĻŽāĻžāϏ)

āĻļ⧁āϰ⧁āϰ āϤāĻžāϰāĻŋāĻ– āĻšāϞ⧋ āϤāĻžāϰāĻŋāĻ– (āĻšāĻŋāϏāĻžāĻŦ āĻļ⧁āϰ⧁āϰ āĻŦāĻŋāĻ¨ā§āĻĻ⧁)āĨ¤

āĻŽāĻžāϏ āĻļ⧁āϰ⧁āϰ āϤāĻžāϰāĻŋāϖ⧇āϰ āĻĒā§‚āĻ°ā§āĻŦ⧇ (āύ⧇āϗ⧇āϟāĻŋāĻ­) āĻ…āĻĨāĻŦāĻž āĻĒāϰ⧇ (āĻĒāϜāĻŋāϟāĻŋāĻ­) āĻŽāĻžāϏ⧇āϰ āϏāĻ‚āĻ–ā§āϝāĻžāĨ¤

āωāĻĻāĻžāĻšāϰāĻŖāϏāĻŽā§‚āĻš

āϏ⧇āĻĒā§āĻŸā§‡āĻŽā§āĻŦāϰ ā§§ā§Ē ⧍ā§Ļā§Ļā§§ āĻāϰ āĻĒāϰ⧇ ā§Ŧ āĻŽāĻžāϏ⧇āϰ āĻļ⧇āώ āĻĻāĻŋāύ āϕ⧋āύāϟāĻŋ?

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


Date & Time Functions

DATE

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

DATEVALUE

DAY

DAYS

DAYS360

DAYSINMONTH

DAYSINYEAR

EASTERSUNDAY

EDATE

EOMONTH

HOUR

ISLEAPYEAR

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

MINUTE

MONTH

MONTHS

NETWORKDAYS

NETWORKDAYS.INTL

NOW

SECOND

TIME

TIMEVALUE

TODAY

WEEKDAY

WEEKNUM

WEEKNUM_ADD

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

WEEKS

WEEKSINYEAR

WORKDAY

WORKDAY.INTL

YEAR

YEARFRAC

YEARS

Please support us!