The Excel MONTH function, returns the month from a supplied date. This is returned as an integer (from 1 - 12).
The syntax of the Month function is:
where the serial_number argument is the date that you want to return the month of.
Note that Excel recommends that dates should be supplied to functions as either:
In the following spreadsheet, the month function is used to extract the month from 3 different dates.
Further examples of the Excel Month function can be found on the Microsoft Office website.
The result of your Month function looks like a date (eg. "01/01/1900"), instead of returning an integer.
Most commonly, this problem arises 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.
To correct this: