MONTH(serial_number) converts a serial number to a month : MONTH « Date Time functions « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Date Time functions
  3. MONTH
Input the formula: =MONTH("15-Apr-2008"). Press Enter to get the result.








15.8.MONTH
15.8.1.MONTH(serial_number) converts a serial number to a month
15.8.2.Determining the Last Day of a Month
15.8.3.Returns the number of days in a month
15.8.4.Determining Whether a Year Is a Leap Year
15.8.5.Returns an integer between 1 and 4 that corresponds to the calendar quarter for the date