Converting a date to just the month in Excel takes two numbers: the month value itself (1 to 12) and the format code that tells Excel how to render it on the screen. Excel stores every date as a serial number counting days from a base date, which is why the same underlying value can appear as "07/06/2026", "July", "Jul", "7", or "07" depending on the format code applied to the cell. The conversion is therefore a display operation, not a calculation, and the original serial number stays intact so any further date math continues to work. In practice, "convert to month" can mean three different things: a cell that displays the month name for a report header, a separate column that returns just the month number for sorting, or a hidden helper that feeds a SUMIFS or COUNTIFS formula. Excel handles all three with the same built-in tools, but the format code you pick changes the result on screen, which is why picking the right code matters more than remembering any single formula. The same logic applies outside Excel: an ISO date in a filename sorts in chronological order, a long-form month name reads more clearly than a numeric one, and a spelled-out date is harder to alter in a legal document. When you want to see every representation of the same date at once, the Date Format Converter shows the ISO, US, European, long-form, weekday, ordinal, and date-to-words outputs on a single screen, with one-click copying.
Excel Methods for Showing Only the Month
Excel ships with four month-only format codes that cover most reports and dashboards. The table below lists the official codes, what they output for a date such as July 6, 2026, and when each is the right pick.
| Format code | Output for 07/06/2026 | Best used for |
|---|---|---|
| m | 7 | Compact tables, charts, and pivot labels where space is tight |
| mm | 07 | Sorting-friendly numeric columns that still show a leading zero |
| mmm | Jul | Short month names in tables, Gantt charts, and timelines |
| mmmm | July | Long-form reports, headings, and any text a non-technical reader will see |
Apply any code through Format Cells. Click Home, expand the Number group, choose More Number Formats at the bottom, then select Custom and type the code in the Type box. Press OK and the cell re-renders without changing the underlying serial number, so formulas like =A2+30 keep working exactly as before. The same steps work for an entire column: select the range, open Format Cells once, and every cell in that range picks up the new display.
Extracting the Month as a Value With a Formula
If you need the month as a number you can multiply, sort, or feed into another formula, use =MONTH(A2) in an adjacent cell. =MONTH returns 7 for July 6, 2026, regardless of how the source cell is formatted. Pair it with =TEXT(A2,"mmmm") to get the full month name "July" as text. These two functions let you build a Month column next to your raw dates without altering them, which is helpful when downstream formulas expect numeric inputs. For readers handling dates that arrive from systems outside Excel, the guide to changing Excel dates to dd/mm/yyyy format walks through the same Format Cells path with a focus on day-month-year order, and pairs naturally with the month-extraction steps above.
Convert a Date to Month Using the Date Format Converter
- Pick a date in the date field on the Date Format Converter; it defaults to today if you just want to see how the current day formats.
- Read every format listed below the field: ISO 8601 (2026-07-06), US numeric (07/06/2026), European numeric (06/07/2026), long month-name forms, weekday, ordinal day, two date-to-words spellings, and Unix timestamp.
- Click Copy on any line to put that exact format on your clipboard, then paste it into Excel, a report, or a database column.
The converter labels each line so you always know whether you are reading month-first or day-first order, which is the easiest way to confirm the month number you plan to paste into a spreadsheet. A quick check on 07/06/2026 shows the US form reads as July, while the same digits in European order (06/07/2026) read as the same day with the numbers swapped, so the tool eliminates the most common source of date-mix-up errors at a glance. The long-form line shows "July 6, 2026", which is the version most readers parse correctly on the first try, while the weekday line adds "Monday" in front for letters and calendar entries.
ISO, US, European, and Long Forms Compared
The table below compares the outputs the converter generates for July 6, 2026. Each row is a real, named convention rather than a custom rendering, so you can decide at a glance which format to paste where.
| Format | Example for July 6, 2026 | Where it fits |
|---|---|---|
| ISO 8601 | 2026-07-06 | Filenames, database columns, log lines, anywhere plain-text sort order matters |
| US numeric | 07/06/2026 | US-only spreadsheets, internal US forms |
| European numeric | 06/07/2026 | UK, EU, AU, NZ forms and most of the world outside the US |
| Long US | July 6, 2026 | Reports, email signatures, formal English-language documents |
| Long European | 6 July 2026 | International correspondence, most non-US English writing |
| Weekday form | Monday, July 6, 2026 | Letters, invitations, calendar entries |
| Date to words (British) | the sixth of July, twenty twenty-six | Cheques, contracts, legal documents |
| Date to words (American) | July sixth, two thousand twenty-six | US cheques, notarised documents |
| Unix timestamp | shown in tool (UTC midnight) | Scripts, APIs, logs expecting seconds since 1970-01-01 UTC |
Because ISO 8601 always reads year-month-day, it sorts correctly as plain text. A column of ISO dates pasted into a CSV or a filename list will line up in chronological order with no extra effort, which is one of the reasons database teams and ISO-aligned tools prefer it over US or European numeric forms. The Date Format Converter labels every line, so the same source date never gets misread as the wrong month once you can see all three numeric styles at once.
Why the Order of the Numbers Matters
The single biggest source of off-by-a-month errors in spreadsheets is reading 07/06/2026 as July 6 one day and June 7 the next. The US system writes month/day/year, so 07/06/2026 is unambiguously July 6 to a US reader. The European system writes day/month/year, so the same 07/06/2026 is July 6 to a UK or EU reader. Both interpretations are valid, and both are common in business documents. ISO 8601 (2026-07-06) avoids the trap entirely by going big-endian from year to day, so any reader in any country lands on the same date without having to guess the convention.
The Date Format Converter shows all three numeric forms side by side for the same date, with each line labelled, which is the fastest way to verify which ordering you are about to paste into a cell. If a colleague overseas asks "is that July 6 or June 7?", the converter turns the question into a one-click check instead of an email thread. For purely in-cell work, the same logic is why saving dates as ISO strings inside a hidden helper column is a safe habit: even if the visible cell uses a local numeric style, the underlying ISO value is unambiguous.
Common Uses for a Month-Only Display
Month extraction shows up in almost every reporting workflow. Quarterly reports need the month name as a row label. Cohort analyses group customers by join month. Payroll exports split earnings by month. Renewal reminders need to fire one calendar month before a subscription ends. In each of these cases the underlying date stays in place and only the visible representation changes, so the data still supports day-level drilldowns whenever a user asks for them.
The same logic applies outside Excel. CSV exports meant for downstream databases usually want ISO 8601 dates, which is why many pipelines reformat on export. Filenames benefit from the same big-endian pattern because a folder of files named 2026-07-06-report.xlsx sorts in date order in any file manager. Legal documents, by contrast, often need the date written out in words to prevent tampering with digits, which is where the date-to-words lines from the converter earn their place. Date-to-words is also a useful safety check whenever a handwritten or printed form could be misread: a spelled-out month removes any doubt about whether the writer meant 06 or 09.
Matching the Format to the Reader
A practical rule is to match the format to the audience and the medium. Internal US spreadsheets can stay numeric and assume month/day. Anything that leaves the building should be either ISO 8601 or a long form that names the month, because writing "07/06/2026" in an international email forces the recipient to ask which convention applies. Anything legal should be written in words on top of the digits, since spelled-out dates are harder to alter silently.
For related work beyond the month display, the guide to converting date format in Excel and online covers day-month-year switching in more depth, and pairs well with the format code and converter steps above when you need both the cell-level and the cross-platform view. Together they cover the bulk of date-format questions that come up in everyday spreadsheet work, from a quick Month column in a sales report to a fully spelled-out date on a contract.