Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Date Time Functions

 

=EOMONTH(01012008,-3) returns the date of the last day of the month, three months before

Input the formula: =EOMONTH(01/01/2008,-3). Press Enter to get the result.