=EDATE("01/15/2003",-1) returns the date, one month before : EDATE « Date Time functions « Microsoft Office Excel 2007 Tutorial





Input the formula: =EDATE("01/15/2003",-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