How to use MONTH Function | Microsoft Excel
MONTH Function is used to know the month of the date given. MONTH Function will return between 1 to 12. Which month is described in the data format.
You can use MONTH Function to feed in other formulas also.
Syntax of MONTH Function
Argument for MONTH Function
serial_number: it is the value from which we get the month number.
Behavior of MONTH Function
Here we have taken four different date format from the format cell option.
First date is
15-09-2018: it will return 9(September)
Second date is
12 January 2018: it will return 1 (January)
Third date is
2018-12-15 : it will return 12 (December)
Fourth date is
08-04-2018: it will return 4 (April)
The MONTH Function will return you an integer between 1 to 12 even if you use any date format which is pre-specified in the Microsoft Excel.
Usage of MONTH Function
To know the month of the given date
Return of MONTH Function
MONTH Function will return an integer value between 1 to 12.
You have written a date in text format
You have entered nothing or other than date format
Example 1 To find the date from the same month
Here we are trying to find the date with same month
Here we have taken two columns with dates and we are using the formula to know the month of the two dates are equal or not
If both the dates have the same month then it will return TRUE otherwise it will return FALSE
Here for the first dates
15-09-2018 and 19-08-2018: Both dates are from the different month so it will return FALSE
12-01-2018 and 31-01-2015: Both dates are from the same month so it will return TRUE
15-12-2018 and 21-08-2018: Both dates are from the different month so it will return FALSE
08-04-2018 and 01-04-2018: Both dates are from the same month so it will return TRUE
Example 2 To convert month number to the month name
Here we take the same example to convert month number to the month name
Here we have used TEXT Function to convert month name into text
=TEXT(B4, “mmmm”) It will return full name of the month
=TEXT(B4, “mmm”) It will return first three letters of the month
15-09-2018: it will return September and Sep
12-01-2018: it will return January and Jan
15-12-2018: it will return December and Dec
08-04-2018: it will return April and Apr