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