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:

Google Sheets: Convert Date to Quarter and Year

Google Sheets: How to Use VLOOKUP by Date

Google Sheets: Calculate Days Between Date and Today