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(StartDate; Months)

StartDate ζ˜―ζŒ‡ζ—₯ζœŸγ€‚

Months ζ˜―ζŒ‡ι–‹ε§‹ζ—₯ζœŸδΉ‹ε‰ (θ² ε€Ό) ζˆ–δΉ‹εΎŒ (ζ­£ε€Ό) ηš„ζœˆζ•Έγ€‚

η―„δΎ‹

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

=EOMONTH(DATE(2001;9;14);6) ζœƒε‚³ε›žεΊθ™Ÿ 37346γ€‚ζ ΌεΌεŒ–η‚Ίζ—₯ζœŸοΌŒε³η‚Ί 2002-03-31。