How to Extract Month from Date in Google Sheets


You can use the following formula to extract the month from a date in Google Sheets:

=TEXT(A1, "MMMM")

This particular formula will return the month from the date in cell A1, formatted as the full month name such as “August.”

Note that you can also use the following abbreviations to return the month formatted in a different way:

  • M: Month of the year as one or two digits (8)
  • MM: Month of the year as two digits (08)
  • MMM: Month of the year as short name (Aug)
  • MMMM: Month of the year as full name (August)
  • MMMMM: First letter of the Month (A)

The following example shows how to use these functions in practice.

Example: Extract Month from Date in Google Sheets

Suppose we have the following list of dates in Google Sheets:

We can use the following formulas to extract the month from each date using different formats:

Extract month from date in Google Sheets

 

The values in column B display the month of the date in column A as 1 or 2 digits.

The values in column C display the month of the date in column A as 2 digits.

The values in column D display the month of the date in column A as the short name.

The values in column E display the month of the date in column A as the full name.

The values in column F display the month of the date in column A as the first letter of the month.

For this particular example, we formatted the dates as 1/1/2022 but the TEXT() function can also easily handle dates in different formats such as:

  • 1/1/22
  • 2022-01-01

Note: You can find the complete documentation for the TEXT() function here.

Additional Resources

The following tutorials explain how to perform other common tasks in Google Sheets:

How to Extract Substring in Google Sheets
How to Filter by Date Range in Google Sheets
How to AutoFill Dates in Google Sheets

Leave a Reply

Your email address will not be published.