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(μ‹œμž‘ λ‚ μ§œ; κ°œμ›”Number)

μ‹œμž‘ λ‚ μ§œλŠ” (계산 μ‹œμž‘ 지점) λ‚ μ§œμž…λ‹ˆλ‹€.

월은 μ‹œμž‘ λ‚ μ§œ 이전(음Number) λ˜λŠ” 이후(μ–‘Number)의 μ›” μˆ˜μž…λ‹ˆλ‹€.

예

2001λ…„ 9μ›” 14일뢀터 6κ°œμ›”μ§Έμ— ν•΄λ‹Ήν•˜λŠ” λ‹¬μ˜ λ§ˆμ§€λ§‰ λ‚ μ§œλ₯Ό κ΅¬ν•΄λ΄…λ‹ˆλ‹€.

=EOMONTH(DATE(2001;9;14);6)λŠ” 일련 번호 37346을 λ°˜ν™˜ν•©λ‹ˆλ‹€. μ„œμ‹μ„ λ‚ μ§œλ‘œ μ§€μ •ν•˜λ©΄ μ΄λŠ” 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!