Rational
Returns Nth months of a date.
Description
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’.
Syntax
=MONTH(serial_number)
Parameters
Serial_number – A valid argument of date, string representation or a serial number of a specific date.
Return Value
An Integer between 1 and 12 (specific month of a year).
Key Notes
- 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.
Keep Reading Similar Functions:
DAY
The DAY function returns an integer value that represents the day element of a date. I.e.; to extract day component, use =DAY(“08-08-2017”) that returns ‘8’.
YEAR
The YEAR function extracts the Year component of a given date. Example; to get or find Year from a date (11/08/2017- cell B5), use =YEAR(B5), returns ‘2017’.
DATEDIF
The DATEDIF is an unknown compatibility function that can be used to calculate the difference between two dates. To find years diff.,=DATEDIF(start_date, end_date,”y”).