How to Convert a Date Into a Month in Excel

What this does

This question hides two different jobs. MONTH() and TEXT() both extract a new value from a date — a number for MONTH(), text for TEXT() — that you can put in another cell, sum, filter, or display separately from the original date. A custom number format does something else entirely: it leaves the cell's underlying date (the serial number Excel actually stores) completely unchanged and only changes what that same cell DISPLAYS. That distinction — change what is stored vs. change how it looks — is the whole answer. Get it backwards and either a report shows the wrong thing, or a formula that expected a real date breaks on a text string. Most people learn this as a sequence of clicks and forget it by next week; learning it as a pattern instead is what lets you apply it to the next, slightly different version of the problem without starting from scratch. That is the difference this page is trying to make. For “convert a date into a month in excel”, the reliable version is a short checking loop, not just the first command that appears to work. Run it on a deliberately small range first, watch how the affected cells change, and only then apply the same setup to the full sheet. When a formula is involved, keep the inputs labelled beside it, reference cells instead of typing values, and apply number formatting only after the result checks out. That is what makes a data step that keeps your analysis trustworthy useful in real work: repeatable, auditable, and not dependent on memory or luck.

A worked example

A2 holds the date 8/12/2026 (a real date, right-aligned in the cell). =MONTH(A2) returns 8. =TEXT(A2,"mmmm") returns "August" as text, left-aligned because it is no longer a date. Selecting A2 itself, pressing Ctrl+1, and setting a Custom format of mmmm changes what A2 shows to "August" while the formula bar still shows 8/12/2026 underneath — a formula like =A2+30 still works correctly on it (still a real date), whereas =TEXT(A2,"mmmm")+30 returns a #VALUE! error, because a text string is not a date no matter how it reads. Whether a report, chart, or filter actually needs a sortable date, a numeric month for calculations, or a readable month name for a label determines which of these three approaches is correct — using the wrong one is a common source of a value that looks right but silently fails to sum, filter, or sort. One habit worth forming early: name the cells that hold your inputs, so the formula reads in plain language instead of a string of cell addresses. A reviewer — or you in three months — can then follow the logic without decoding what B7 and D2 were supposed to mean, which is most of what makes a sheet maintainable.

In Google Sheets

If you are in Google Sheets rather than Excel, the good news is that the formula shown here is identical and the workflow barely changes — menus sit across the top instead of in a ribbon, and a few function names differ slightly, but anything you build here moves across with little or no rework. The aim was to get you unstuck fast and leave you a little more capable than a copy-paste would. The answer is at the top and the detail above shows why it holds — so the next time a colleague asks, you can answer without reaching for search. Treat “convert a date into a month in excel” as a small building block rather than a chore. Once the inputs sit in their own cells and the formula reads from them, the same setup answers a dozen related questions with a tweak, and Excel keeps every dependent figure current as the data changes. The tool above is there so you can rehearse and verify before committing anything to a real workbook; the steps and worked example are there so the logic sticks. Get it right once and it stops costing you time — it starts saving it, every time the question comes back around.

Common mistakes

• Applying a custom mmmm format and then thinking the date "changed" — the formula bar always shows the real underlying date; only the cell's displayed text changed.
• Using =TEXT(A2,"mmmm") when a month NUMBER was actually needed for a SUMIFS/COUNTIFS criterion — TEXT returns text, which will not match a numeric month condition.
• Feeding a TEXT()-converted month name into further date arithmetic (adding days, comparing to another date) and getting a #VALUE! error, because it is no longer a date at all.
• Typing "MM" inside a format or TEXT code next to "hh" and getting minutes instead of a month — Excel reads mm as minutes only when it sits next to an hour code, and as month everywhere else.

Frequently asked questions