Get Month Name from a Date

Worked Example

Result: Returns May from the date value.

Steps

• Make sure the source value is a real date.
• Use TEXT with mmmm for the full month name.
• Use mmm for a short label.
• Use a real month-start date for calculations and TEXT only for display.

Common Mistakes

• Using month names as calculation keys instead of real dates.
• Applying TEXT to dates stored as unrecognized text.
• Sorting month names alphabetically instead of calendar order.

Excel vs Google Sheets Notes

The core idea works in both Excel and Google Sheets, but separators, function availability, and array behavior can vary by account, locale, and version.

FAQ