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(é–‹ć§‹æ—„; 月)

é–‹ć§‹æ—„ ăŻă€æ—„ä»˜ă§ă™ă€‚

月 ăŻă€é–‹ć§‹æ—„ăźć‰ (èČ ăźæ•°) ăŸăŸăŻă‚ăš (æ­Łăźæ•°) ăźæœˆæ•°ă§ă™ă€‚

䟋

2001ćčŽ3月31æ—„ă‚ˆă‚Š1ăƒ¶æœˆć‰ăźæ—„ä»˜ă‚’æ±‚ă‚ăŸă™ă€‚

=EOMONTH(DATE(2001;9;14);6) は、シăƒȘă‚ąăƒ«ć€€ 37346 ă‚’èż”ă—ăŸă™ă€‚æ—„ä»˜ćœąćŒă«ă™ă‚‹ăš 2002-03-31 です。