EOMONTH

μ‹œμž‘ λ‚ μ§œμ—μ„œ λͺ‡ κ°œμ›” μ§€λ‚œ 월에 ν•΄λ‹Ήν•˜λŠ” μ›”μ˜ λ§ˆμ§€λ§‰ λ‚ μ˜ λ‚ μ§œλ₯Ό λ°˜ν™˜ν•©λ‹ˆλ‹€.

μ°Έκ³  μ•„μ΄μ½˜

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


Syntax

EOMONTH(μ‹œμž‘ λ‚ μ§œ; κ°œμ›”Number)

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

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

Example

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

=EOMONTH(DATE(2001;9;14);6)λŠ” 일련 번호 37346을 λ°˜ν™˜ν•©λ‹ˆλ‹€. μ„œμ‹μ„ λ‚ μ§œλ‘œ μ§€μ •ν•˜λ©΄ μ΄λŠ” 2002-03-31μž…λ‹ˆλ‹€.

=EOMONTH("2001-09-14";6)λŠ” 잘 μž‘λ™ν•©λ‹ˆλ‹€ λ‚ μ§œλ₯Ό λ¬Έμžμ—΄λ‘œ μ§€μ •ν•˜λ €λ©΄ ISO ν˜•μ‹μ΄ λ˜μ–΄μ•Ό ν•©λ‹ˆλ‹€.

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!