Date Time Functions MSOfficeExcel 2007 Tutorial

  1. Home
  2. MSOfficeExcel 2007 Tutorial
  3. Date Time Functions
  4. EOMONTH(start_date,months) returns the last day of the month before or after a specified number of months
=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.