Returns Nth months of a date.
The Excel MONTH function extracts an integer between 1 and 12 that corresponds to the month component of a given date. Example, to get month component of a date (8/15/2017) in cell B5, use =MONTH(B5) that returns ‘8’.
Serial_number – A valid argument of date, string representation or a serial number of a specific date.
An Integer between 1 and 12 (specific month of a year).
- A valid date format in the function may be entered in time, text and serial number format in the specific cell of the worksheet.
- Isolating the month part of a date is appropriate if the application of only month component is required in a specific argument.
- In MONTH function we can’t use a date directly in the formula as a text like =MONTH(03/15/2018) because of the Excel store date in the serial number.