Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Date Time Functions

 

=EDATE(01152003,-1) returns the date, one month before

Input the formula: =EDATE("01/15/2003",-1). Press Enter to get the result.