In this Article
This tutorial will teach you how to get the name of a month from a date in Excel and Google Sheets.
Get Month Using Month Function
You can calculate the month number of a date by using the Month Function:
Get Month By Changing Formatting
By changing a date’s Date Format to “MMMM” you can see the month name:
or “MMM” to see the month abbreviation:
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:
Open the Number Tab of the Cell Formatting menu. This can be accessed with the shortcut CTRL + 1 or by clicking this button on the Home Ribbon:
Next navigate to the Custom section.
The Custom section of the Format Cells Menu allows you the ability to create your own number formats:
To set custom number formatting for dates, you’ll need to specify how to display days, months, and / or years. Use this table as guide:
Notice you can use “mmm” or “mmmm” to display the month name.
Text – Month
You can also use the TEXT Function to output the month number as the month name using the same formatting rules as above:
We can also use the CHOOSE Function to calculate the month name of a date:
Get Month Name in Google Sheets
You can calculate the month name of a date the same in Google Sheets as in Excel: