EOMONTH(start_date,months) returns the last day of the month before or after a specified number of months : EOMONTH « Date Time functions « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Date Time functions
  3. EOMONTH
=EOMONTH(01/01/2008,1) returns the date of the last day of the month, one month after

Input the formula: =EOMONTH(01/01/2008,1). Press Enter to get the result.
15.5.EOMONTH
15.5.1.EOMONTH(start_date,months) returns the last day of the month before or after a specified number of months
15.5.2.=EOMONTH("01/01/2008",-3) returns the date of the last day of the month, three months before