Table of Contents
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.