Dates & Time

Excel formula for Get the month name from a date

Convert a date into its month name like "January" using TEXT.

Copy this formula

=TEXT(A2, "mmmm")

How the formula works

TEXT formats a date as text using a pattern. "mmmm" gives the full month name, "mmm" gives the short name (Jan), and "mm" gives the two-digit number.

=TEXT("2026-06-23", "mmmm")→June

Returns the full month name.

Day of week name

=TEXT(A2, "dddd")

Returns the weekday, e.g. Tuesday.

I want the month number, not the name.

Use =MONTH(A2) to return 1–12 as a number.

Need a formula for your own data?

Describe what you want in plain language and let ExcelGPT write, explain, and verify the formula — free to start, no plugin.