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(ΠΠ°ΡΠ°Π»ΡΠ½Π°Ρ Π΄Π°ΡΠ°; ΠΠ΅ΡΡΡΡ)
ΠΠ°ΡΠ°Π»ΡΠ½Π°Ρ Π΄Π°ΡΠ°: Π΄Π°ΡΠ°.
ΠΠ΅ΡΡΡΡ: ΡΠΈΡΠ»ΠΎ ΠΌΠ΅ΡΡΡΠ΅Π² Π΄ΠΎ (ΠΎΡΡΠΈΡΠ°ΡΠ΅Π»ΡΠ½ΠΎΠ΅) ΠΈΠ»ΠΈ ΠΏΠΎΡΠ»Π΅ (ΠΏΠΎΠ»ΠΎΠΆΠΈΡΠ΅Π»ΡΠ½ΠΎΠ΅) Π½Π°ΡΠ°Π»ΡΠ½ΠΎΠΉ Π΄Π°ΡΡ.
What date is one month prior to 2001-03-31?
=EOMONTH(DATE(2001;9;14);6) Π²ΠΎΠ·Π²ΡΠ°ΡΠ°Π΅Ρ ΠΏΠΎΡΡΠ΄ΠΊΠΎΠ²ΡΠΉ Π½ΠΎΠΌΠ΅Ρ 37346. ΠΡΠΈ ΡΠΎΡΠΌΠ°ΡΠΈΡΠΎΠ²Π°Π½ΠΈΠΈ Π² Π²ΠΈΠ΄Π΅ Π΄Π°ΡΡ Π·Π½Π°ΡΠ΅Π½ΠΈΠ΅ ΠΎΡΠΎΠ±ΡΠ°ΠΆΠ°Π΅ΡΡΡ ΠΊΠ°ΠΊ 2002-03-31.