The Excel MONTH function, when supplied with a date, returns an integer representing the month of the year (from 1 - 12).
The format of the function is :
where the date argument can be supplied to the function as either :
Warning: If you attempt to input the date argument as text, there is a chance that Excel may misinterpret this, depending on the date system, or date interpretation settings on your computer.
Also, although you can input the date as a serial number, this is not recommended, as the serial numbers may vary across different computer systems.
The following example shows the month function used to extract the month from 3 different dates. The spreadsheet on the left shows the format of the function and the spreadsheet on the right shows the results for the 3 dates.
Note that, in the above examples, as recommended by Microsoft, the date value is always supplied as either a reference to a cell containing a date, or as a value returned from another function.
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.
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,
- Read more about Excel Formatting here