# How to use MONTH Function | Microsoft Excel

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.

### 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.

### Error Values

 Error Commands Description #VALUE You have written a date in text format 1 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

=MONTH(B4)=MONTH(C4)

Here for the first dates

15-09-2018 and 19-08-2018: Both dates are from the different  month so it will return FALSE

Second Dates

12-01-2018 and 31-01-2015: Both dates are from the same month so it will return TRUE

Third Dates

15-12-2018 and 21-08-2018: Both dates are from the different month so it will return FALSE

Fourth Dates

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

First Date

15-09-2018: it will return September and Sep

Second Date

12-01-2018: it will return January and Jan

Third Date

15-12-2018: it will return December and Dec

Fourth Date

08-04-2018: it will return April and Apr