Better Sheets

How to Use MONTH() in Google Sheets

Description

Returns the month of the year a specific date falls in, in numeric format.

How To Actually Use MONTH() in Sheets

MONTH(date)

Try MONTH yourself

In cell B1, use the MONTH() formula to extract the month from the date in cell A1. The correct answer should return a number between 1 and 12.

Your formula

Hints (2)

Locale Separator ,

Official Docs

3 Better Sheets Tutorials

Building a Year Progress Clone

Create a year progress bar to see how much of the year is gone. Great motivational chart to watch count up to 100%.

EOMONTH() HOUR() MONTH() NOW() SPARKLINE() +3 more

What is this Ampersand Doing in Google Sheets?

What is "&" doing in this formula? MONTH(A1&1)
Do you know why this is so cool? It can replace an entire vlookup chart I've been making for years.

CONCAT() DATE() MONTH() VALUE()

Can I Automatically Rename a Sheet based on a Date?

Change the title of a spreadsheet from within a cell in the spreadsheet.

Intermediate

DAY() MONTH() TODAY() YEAR()

Transcript-matched member videos for MONTH(). Click through to watch.

Browse more tutorials

Hardest Formula: SumIF | Addition Based on Dates / Values

Demystifying the SumIF Formula. Add up your values based on a condition,...

SUMIF() UNIQUE()

Calculate ROAS in Google Sheets

Calculate Return on Ad Spend with a formula combination. Bonus: create a...

Intermediate

CONCATENATE() ROUND()

Google Sheet Basics - The Absolute Basics

Let's start at the basics of Google Sheets. Where every beginner spreads...

Beginner

Write Apps Script to Create a New Google Sheets Formula

Create a brand new custom formula in Apps Script. We'll do this for our ...

Unlock these tutorials

Learn more about the MONTH() formula:

Generate a MONTH() formula for your needs

Describe your task in plain English and get a paste-ready formula that uses MONTH(). 2 free AI generations, no signup. Members get unlimited use.

Generate a MONTH() formula