The Excel MONTH Function
Function Description
The Excel MONTH function, returns an integer, representing the month (from 1 - 12) of a supplied date.
The syntax of the function is:
MONTH( serial_number )
where the serial_number argument is the date that you want to return the month of.
Note that it is recommended that dates should be supplied to Excel functions as either:
- Serial numbers;
- Reference to cells containing dates;
- Date values returned from other Excel formulas.
Month Function Examples
Column B of the following spreadsheet shows the Excel Month function, used to extract the month from three different dates.
|
Formulas:
|
Results:
|
Note that, in the above examples:
- As recommended, the dates are supplied as references to cells containing dates or (in the example in cell B3), as a date returned from another Excel function.
- The example in cell B3 uses the Excel Date function to supply the date 01-Jul-2015 to the Month function.
For further examples of the Excel Month function, see the Microsoft Office website.
Excel Month Function Common Problem
Common Problem:
The result of your Month function looks like a date (e.g. "01/01/1900"), instead of returning an integer.
Solution:
This problem is most likely to be because the new cell or column is formatted as a 'date'. In this case, it is only the formatting of the cell that is wrong, NOT the value returned by the function.
The easiest way to do correct this is to select the General formatting option from the drop-down format menu of the Excel ribbon. This is generally located in the 'Number' group, on the Home tab of the ribbon (see below):
See the Excel Formatting page for more information on formatting in Excel.