Arrow left
Back to product guides
Google Sheets Formulas

MONTH Function in Google Sheets: Explained

In this article, you will learn how to use the MONTH formula in Google Sheets. 

What does the MONTH Function do in Google Sheets?

The MONTH function returns the month from a given date. The MONTH function is beneficial when extracting the month from a specific date. For instance, the MONTH formula is helpful when you need to check each client’s contract month from a detailed client list containing contract dates for a year.

How to use the MONTH formula in Google Sheets

  1. Type “=MONTH” or go to “Insert”“Function” (or directly navigate to the “Functions” icon)  “Date”“MONTH”.
  2. Input a date manually or refer to a cell containing a date.
  3. Press the “Enter” key.
How to insert the MONTH formulas from the menu bar in Google Sheets

The general syntax is as follows:

=MONTH(date)

Date: the date from which the formula pulls out the month

Imagine that you look at your client list containing contract dates with your customers and want to know which month you agreed with each client. Look at the following screenshot to understand how the MONTH function works in Google Sheets.

How the MONTH function works in Google Sheets

As you can see, the formula is simple. The MONTH function needs only one argument: a date or a cell reference to a cell containing a date. In the example above, the MONTH function in cell D3 refers to cell C3 containing “12/5/2022”; thus, the formula returns “12”. You can use this information in column D to sort the data by month with a filter or filter view, as described in the following section, or count the number of contracts each month by using the COUNTIF or the COUNTIFS function. If you are interested in the COUNTIF and COUNTIFS functions, check these articles: How to Use COUNTIF Function in Google Sheets / How to Use COUNTIFS function in Google Sheets

How do I filter by month in Google Sheets?

Once you have a table containing a column showing the month of each item, as you can see in the picture in the section above, you can set up a filer or filer view for the table. You can sort the data in the table by month with a filter or filter view. To learn a filter and filter view in Google Sheets, please check these articles: Filter in Google Sheets: Explained / Filter Views in Google Sheets: Explained.

How do I make text in a month in Google Sheets?

To learn text formatting and how to make text in a month, go to this webpage explaining the TEXT function: TEXT Function in Google Sheets: Explained

Other formulas related to date and time

If you don’t get the correct answer to your question in this article or have other questions related to date and/or time, you may find the answers in the following articles.

Formulas related to dates

How to Use EDATE Function in Google Sheets - understand a date before/after a specific number of days

DAYS Function in Google Sheets: Explained - calculate the number of days between the two dates

WORKDAY Function in Google Sheets: Explained - show the ending date based on inputs of specific starting date and the number of working days, excluding holidays

NETWORKDAYS Function in Google Sheets: Explained - calculate the number of working days between two dates, excluding holidays

EOMONTH Function in Google Sheets: Explained - understand an end date of a month

DATEVALUE Function in Google Sheets: Explained - convert a date into a serial number

YEAR Function in Google Sheets: Explained - extract the year from a given date

DAY Function in Google Sheets: Explained - the day from a given date

DATE Function in Google Sheets: Explained - create a date value based on year, month and day input

Formulas related to time

How to Insert Current Time in Google Sheets - NOW function

You can learn about other Google Sheets formulas and tips that are not mentioned here on this page: LiveFlow‘s How to Guides

Analyze your live financial data in a snap

Are you learning this formula to visualize financial data, build a financial model, or conduct financial analysis? In that case, LiveFlow may help you automate manual workflows and update numbers in real-time. You can access various financial templates on our website, from the simple Income Statement to Multi-Currency Consolidated Financial Statement. You can also customize these templates as you want without breaking the automated data inflow.

To learn more about LiveFlow, book a demo.

Automate any custom financial dashboard in Google Sheets with LiveFlow

Learn how to do this step-by-step in the video below 👇

Do you need personal help?

Our team of real people are here to help you any time between 9am and 10pm GMT.
Check Icon
Email us at: founders@liveflow.io
Check Icon
Call us at +1 (415) 650-1711