Table of Contents
To display the date in Google Sheets as the name of the month, follow these steps:
1. Select the cell where you want to display the month name
2. In the formula bar, type “=TEXT(A1,”MMMM”)” (replace A1 with the cell containing the date)
3. Press Enter and the cell will display the name of the month corresponding to the date.
This formula utilizes the TEXT function in Google Sheets to convert the date format into a month name. By following these steps, you can easily display the date in your desired format in Google Sheets.
Google Sheets: Show Date as Month Name
You can use the following formulas to show a date as a month name in Google Sheets:
Formula 1: Show Date as Full Month Name
=TEXT(A2, "mmmm")
This particular formula will display the full month name of the date in cell A2.
For example, if cell A2 contains 1/1/2023 then the formula will return January.
Formula 2: Show Date as Abbreviated Month Name
=TEXT(A2, "mmm")
This particular formula will display the abbreviated month name of the date in cell A2.
For example, if cell A2 contains 1/1/2023 then the formula will return Jan.
The following examples show how to use each formula in practice with the following column of dates in Google Sheets:
Example 1: Show Date as Full Month Name
We can use the following formula to return the full month name for the date in cell A2:
=TEXT(A2, "mmmm")
We can type this formula into cell B2 and drag the formula down to every remaining cell in column B:
Column B displays the full month name of each date in column A.
Example 2: Show Date as Abbreviated Month Name
We can use the following formula to return the abbreviate month name for the date in cell A2:
=TEXT(A2, "mmm")
We can type this formula into cell B2 and drag the formula down to every remaining cell in column B:
Column B displays the abbreviated month name of each date in column A.
Additional Resources
The following tutorials explain how to perform other common tasks in Google Sheets: