EDATE

The result is a date which is a number of months away from the start date. Only months are considered; days are not used for calculation.

ꡬ문

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

μ‹œμž‘μΌμ€ λ‚ μ§œ ν˜•μ‹μž…λ‹ˆλ‹€.

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

예

What date is one month prior to 2001-03-31?

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