Excel Formula – Get Month Name From Date

This tutorial will teach you how to get the name of a month from a date in Excel and Google Sheets.

Get month name Main

Get Month Using Month Function

You can calculate the month number of a date by using the Month Function:

Get month Month

Get Month By Changing Formatting

By changing a date’s Date Format to “MMMM” you can see the month name:

Month MMMM

or “MMM” to see the month abbreviation:

Month MMM

Note: This will display the month name, but the value stored in the cell will still be the month number.

Change Number Format

To change the number format follow these steps:

<<<Steve insert directions!!>>

Text – Month

You can also use the TEXT Function to output the month number as the month name:

TEXT Month

Choose Month

We can also use the CHOOSE Function to calculate the month name of a date:

Choose Month

Get Month Name in Google Sheets

You can calculate the month name of a date the same in Google Sheets as in Excel:

Get month name Google sheet