How to use MONTH Function | Microsoft Excel

How to use MONTH Function | Microsoft Excel

how to use month function

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

=MONTH(serial_number)

 Argument for MONTH Function

serial_number: it is the value from which we get the month number.

Behavior of MONTH Function

how to use 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

More Example

Example 1 To find the date from the same month

Here we are trying to find the date with same month

how to use month function


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

how to use month function



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

Leave a Reply

Your email address will not be published. Required fields are marked *