Table of Contents
In Google Sheets, the function “MONTH” can be used to extract the month from a given date. This function takes a date as an input and returns the month in numeric form. For example, if the date is “January 15, 2021”, the function would return “1” for the month of January. This allows users to easily manipulate and organize data based on specific months within their spreadsheet. To use this function, simply type “=MONTH(date)” into a cell, replacing “date” with the cell reference or actual date. The result will be the month number, from 1 to 12, corresponding to the date provided. This feature is useful for various data analysis and organization tasks in Google Sheets.
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:
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.
- 1/1/22
- 2022-01-01
Note: You can find the complete documentation for the TEXT() function .
Additional Resources
The following tutorials explain how to perform other common tasks in Google Sheets:
Cite this article
stats writer (2024). How can I extract the month from a date in Google Sheets?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-extract-the-month-from-a-date-in-google-sheets/
stats writer. "How can I extract the month from a date in Google Sheets?." PSYCHOLOGICAL SCALES, 29 Jun. 2024, https://scales.arabpsychology.com/stats/how-can-i-extract-the-month-from-a-date-in-google-sheets/.
stats writer. "How can I extract the month from a date in Google Sheets?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-extract-the-month-from-a-date-in-google-sheets/.
stats writer (2024) 'How can I extract the month from a date in Google Sheets?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-extract-the-month-from-a-date-in-google-sheets/.
[1] stats writer, "How can I extract the month from a date in Google Sheets?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How can I extract the month from a date in Google Sheets?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.