EDATE(start_date,months) returns the date that is the indicated number of months before or after the start date : EDATE « Date Time functions « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Date Time functions
  3. EDATE
=EDATE("01/15/2002",1) returns the date, one month after

Input the formula: =EDATE("01/15/2002",1). Press Enter to get the result.
15.4.EDATE
15.4.1.EDATE(start_date,months) returns the date that is the indicated number of months before or after the start date
15.4.2.=EDATE("01/15/2003",-1) returns the date, one month before