MONTH
TheMONTH
formula is used to extract the month from a given date, returning it as a number between 1 and 12. This function is commonly used to summarize and analyze data that includes dates.
 How to use
MONTH
formula?  Examples of using
MONTH
formula MONTH
formula not working? Similar formulas to
MONTH
Usage
Use the MONTH
formula with the syntax shown below, it has 1 required parameter:
 date (required):
The date from which the month should be extracted. This parameter should be a valid Google Sheets date or a reference to a cell containing a date.
Examples
Here are a few example use cases that explain how to use theMONTH
formula in Google Sheets.
Calculating monthly totals
The MONTH
function can be used to calculate monthly totals for a range of data that includes dates. By grouping the data by month, you can easily see trends and patterns over time.
Highlighting birthdays
The MONTH
function can be used to highlight birthdays in a list of contacts or employees. By comparing the month of each person's birthday to the current month, you can create conditional formatting rules that highlight upcoming birthdays.
Filtering by month
The MONTH
function can be used to filter data by month, allowing you to focus on specific time periods. For example, you can use this function to filter a sales report to only show data from a specific month.
Common Mistakes
MONTH
not working? Here are some common mistakes people make when using the MONTH
Google Sheets Formula:
No date provided
If no date is provided as input, the MONTH formula will return an error. Make sure to provide a valid date as input.
Invalid date format
If the date provided is in an invalid format, the MONTH formula will return an error. Make sure the date is in a valid format for Google Sheets.
Using text instead of a date
If you provide text instead of a date as input, the MONTH formula will return an error. Make sure to provide a valid date as input.
Related Formulas
The following functions are similar to MONTH
or are often used with it in a formula:

YEAR
The YEAR formula in Google Sheets returns the year of a specified date. This function is useful when you need to extract the year from a date for analysis or calculations. The YEAR formula takes one argument, which is the date from which to extract the year. The output is a fourdigit number representing the year.

DAY
The
DAY
function is used to extract the day of the month from a given date. It takes in a single argument, a date in a valid format, and returns the day of the month as a number between 1 and 31. This function can be useful for tasks such as sorting or filtering data based on the day of the month. 
DATE
The
DATE
formula is used to create a date object in Google Sheets. It takes three arguments: year, month, and day and returns a date. This formula is useful when you need to perform date calculations or create datebased charts and graphs. 
EDATE
The
EDATE
function in Google Sheets returns a date that is a specified number of months before or after a specified date. It is most commonly used to calculate due dates for invoices, project deadlines, or loan repayments.
Learn More
You can learn more about the MONTH
Google Sheets function on Google Support.