This post will guide you how to use Google Sheets MONTH function with syntax and examples.
Description
The Google Sheets MONTH function returns the month of a date represented by a serial number. And the month is an integer number from 1 to 12. And you can use the MONTH function to get a month component from a given date value. And you can feed the month number to another formula.
The MONTH function can be used to extract the month from a given date as a number between 1 to 12 in google sheets. The purpose of this function is to get MONTH as a number from a date and its returned values is a number between 1 and 12.
The MONTH function is a buildin function in Google Sheets and it is categorized as a Date function.
Syntax
The syntax of the MONTH function is as below:
=MONTH (date)
Where the MONTH function argument is:

Date This is a required argument. A valid date value that contains the month component you want to extract. Dates should be entered by using the DATE function, or as results of other formulas or functions. For example, use DATE (2021,3,15) for the 15th day of March, 2021.
Note:
 You need to make sure that the Date argument is a cell reference that containing a date, or a function which returns a date value or a date serial number.
 If
Date
argument is not recognized, MONTH function will return #VALUE! Error message.
 If
Date
argument is supplied as a date number that is out of range, MONTH function will return #NUM! error message.
 You can use the MONTH function to extract a month component from a given date, or using this function to feed a month number into another function to create a more complex formula like the DATE function.
 Date argument can be supplied to the MONTH function as a date text string (e.g. “2021/11/13” or “Nov112021”). Or creating a date value with separate year, month, and day by using the DATE function.
Google Sheets MONTH Function Examples
The below examples will show you how to use google sheets MONTH Function to return an integer number that representing the month component of a given date.
1# get month of the date in Cell A1, enter the following formula in Cell B1.
=MONTH(A1)
2# convert Month name to number, type the following formula in Cell B1.
You should use the DATEVALUE function to convert a date stored as text to a serial number. Then feed the result into the MONTH function to extract a month number from date.
=MONTH(DATEVALUE(A1 & "1"))
Related Posts
Add Months To Date In Google Sheets
It is important to adjust time periods when performing financial modeling. In Google Sheets, you can use the MONTH function to add a specific number of months to a date. The MONTH function takes one argument: the number of months ...
Google Sheets EXP Function
This post will guide you how to use Google Sheets EXP function with syntax and examples. Description The Google Sheets EXP function returns e raised to the power of a number. The constant e is equal to 2.71828182845904, and it ...
Google Sheets FACT Function
This post will guide you how to use Google Sheets FACT function with syntax and examples. Description The Google Sheets FACT function returns the factorial of a given number. The factorial of a given number is equal to 1*2*3…* number. ...
Google Sheets EVEN Function
This post will guide you how to use Google Sheets EVEN function with syntax and examples. Description The Google Sheets EVEN function rounds a given number up to the nearest even integer. You can use the EVEN function to return ...
Google Sheets COUNTBLANK Function
This post will guide you how to use Google Sheets COUNTBLANK function with syntax and examples. Description The Google Sheets COUNTBLANK function use to count the number of empty cells in a range of cells. You can use the COUNTBLANK ...
Google Sheets DEGREES Function
This post will guide you how to use Google Sheets DEGREES function with syntax and examples. Description The Google Sheets DEGREES function converts radians into degrees. And it will return a numeric value. For examples, if you pass the PI() function into ...
Google Sheets COSH Function
This post will guide you how to use Google Sheets COSH function with syntax and examples. Description The Google Sheets COSH function returns the hyperbolic cosine of a given angle. The purpose of this function is used to get hyperbolic ...
Google Sheets COS Function
This post will guide you how to use Google Sheets COS function with syntax and examples. Description The Google Sheets COS function returns the cosine of a given angle. If you want to supply an angle to COS function in ...
Google Sheets COMBINA Function
This post will guide you how to use Google Sheets COMBINA function with syntax and examples. Description The Google Sheets COMBINA function returns the number of combinations for a given number of items and it includes repetitions. You can use ...
Google Sheets COMBIN Function
This post will guide you how to use Google Sheets COMBIN function with syntax and examples. Description The Google Sheets COMBIN function returns the number of combinations for a given number of items. And you can use the COMBIN function ...