Skip to Content

How to Use the Month Function in Google Sheets

If you are working with dates in Google Sheets and only want to use the month of the year that date falls on, the MONTH function is a useful formula to learn.

In this tutorial, I will show you how to use the MONTH function in Google Sheets.

MONTH Syntax

The month function will take a date and return the month of the year that that date falls on in numeric format

The syntax of the MONTH function is:


  • date – this is the date that what be used to extract the month from. It can be a cell reference to a cell containing a date, a function returning a date, or a number

The most important thing to be aware of when using this function is to make sure that your cell actually contains a date.

If you have a number in a cell and it is not an actual date value, you may end up with problems when using the function

Using the MONTH Function

The month function is very easy to use since there is only one parameter which is the date that you will extract the month from.

Here are a few examples of using the function:

MONTH Function

To use the function simply put the cell containing the date inside the single argument of the function.

As you can see from the examples above, this formula just takes the date and returns the number corresponding to the month.

The key to using this formula is making sure your dates are in the right format.

If the formula is returning an error, the data in your cell is probably not a date.

Closing Thoughts

If you’re working with dates in Google Sheets but only need the month extracted from your data, this is a useful function to know. It shouldn’t take you long to master, as it is a pretty self-explanatory function.

You can combine this with other formulas to do even more powerful things once you get comfortable using it.

More Google Sheets Tutorials:
How to Use the ISDATE Function
How to Use the DATEDIF Function
How to Convert Month Name to Number