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(αƒ‘αƒαƒ¬αƒ§αƒ˜αƒ‘αƒ˜ αƒ—αƒαƒ αƒ˜αƒ¦αƒ˜;αƒ—αƒ•αƒ”αƒ”αƒ‘αƒ˜)

αƒ‘αƒαƒ¬αƒ§αƒ˜αƒ‘αƒ˜ αƒ—αƒαƒ αƒ˜αƒ¦αƒ˜: αƒ—αƒαƒ αƒ˜αƒ¦αƒ˜.

Months is the number of months before (negative) or after (positive) the start date.

αƒ›αƒαƒ’αƒαƒšαƒ˜αƒ—αƒ˜

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

=EDATE("2001-03-31";-1) returns the serial number 36950. Formatted as a date, this is 2001-02-28.