Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Date Time Functions

 

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.