Date Time Functions MSOfficeExcel 2007 Tutorial

  1. Home
  2. MSOfficeExcel 2007 Tutorial
  3. Date Time Functions
  4. EDATE(start_date,months) returns the date that is the indicated number of months before or after the start date
=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.