EDATE/text/scalc/01/func_edate.xhpEDATE functionEDATE
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.SyntaxEDATE(StartDate; Months)StartDate is a date.Months is the number of months before (negative) or after (positive) the start date.ExampleWhat date is one month prior to 3.31.2001?=EDATE(3.31.2001;-1) returns 2.28.2001.