XLS LibraryXLS Library
Excel Formulas & Functions

Excel: What Month Is It? Practical Month Extraction

A practical guide to determining the current month in Excel using MONTH, TEXT, and related date functions. Learn numeric months, full month names, locale considerations, and dashboard-ready techniques for reliable month-based analysis.

XLS Library
XLS Library Team
·5 min read
Excel TipsFormula SyntaxVlookupExcel FormulasSpreadsheets
Current Month in Excel - XLS Library
Photo by Negative Spacevia Pexels
Quick AnswerDefinition

Excel helps you identify the current month from dates with simple formulas. Use MONTH(TODAY()) for a numeric month (1-12) and TEXT(TODAY(), "mmmm") for the full month name. To anchor results to a specific date, replace TODAY() with a cell reference. For locale-aware month names, adjust your regional settings accordingly. These basics unlock many calendar analytics, such as monthly totals, period comparisons, and dynamic dashboards.

Understanding month-related concepts in Excel date math

In Excel, the concept of a month is a component of a date value. The MONTH function isolates the month number (1 through 12) from any valid date, while TEXT formats can output a month name. Since calendars are locale-sensitive, the same date can yield different month spellings depending on regional settings. Today’s date serves as a convenient anchor for demonstrations, which is crucial in building repeatable month-based analyses.

Excel Formula
=MONTH(DATE(2026,2,28)) ' numeric month (2)
Excel Formula
=TEXT(DATE(2026,2,28),"mmmm") ' full month name (February)

descriptionCountedWordsInBlockAndCodeExamplesEnableValidationReasoningRestHoweverEmptyNot

wordCountSectionNoteThisBlockHasNoDirectWordCount

paragraphsNoteThisBlockContainsMarkdownAndCodeFences

dateNotesThisBlockIllustratesMonthFromDate

Steps

Estimated time: 20-30 minutes

  1. 1

    Set up a date column

    Enter sample dates in a column (e.g., A2:A6) to experiment with month extraction. Include a mix of dates across different months to observe results.

    Tip: Use the Fill Series feature to generate consecutive dates quickly.
  2. 2

    Extract numeric month

    In B2, enter =MONTH(A2) and copy down. This returns the numeric month (1-12) for each date in A2.

    Tip: Lock references if you copy across multiple rows.
  3. 3

    Display month names

    In C2, use =TEXT(A2,"mmmm") to display the full month name (e.g., February) and =TEXT(A2,"mmm") for an abbreviated form.

    Tip: TEXT preserves readability for dashboards.
  4. 4

    Anchor to current month for dashboards

    Use =DATE(YEAR(TODAY()),MONTH(TODAY()),1) to get the first day of the current month. Use =EOMONTH(TODAY(),0) for the last day.

    Tip: Combine with SUMIFS or pivot tables for dynamic monthly reports.
Pro Tip: Consider using TEXT with a locale code like "[$-409]mmmm" to standardize month names across users.
Warning: Beware of different date systems (1900 vs 1904) which can shift month calculations in older workbooks.
Note: When copying formulas down a table, use relative references for the date column and absolute references where needed.
Pro Tip: Create a named range for your date column to simplify complex month-based formulas.

Prerequisites

Required

  • Excel 2016 or newer (Windows or macOS)
    Required
  • Basic familiarity with TODAY, DATE, YEAR, MONTH functions
    Required
  • Understanding TEXT for month names and locale-aware formats
    Required

Optional

  • Optional: locale/region settings awareness for consistent month names
    Optional

Keyboard Shortcuts

ActionShortcut
CopyCopy selected cells/headersCtrl+C
PastePaste copied content into cells or formulasCtrl+V
Format CellsOpen the Format Cells dialog for number/date formattingCtrl+1
Fill DownCopy the formula down a columnCtrl+D
FindSearch within the worksheetCtrl+F

People Also Ask

What is the difference between MONTH and TEXT for months?

MONTH returns just the month number (1-12) from a date, while TEXT formats the same date into a month name. TEXT can output in full, abbreviated, or locale-specific language. Use them together to build readable month labels for reports.

MONTH gives you a number from 1 to 12, while TEXT turns the date into a readable month name like February. Both are useful for dashboards depending on whether you need numeric grouping or textual labels.

Can I get month names in different languages?

Yes. Use TEXT with a locale code in the format string, such as TEXT(TODAY(),"[$-409]mmmm") for US English or other locale codes for languages like German or French. This ensures consistency across regional users.

You can enforce language using a locale in the format string, so everyone sees the same month name regardless of their system settings.

How do I reference a date in another cell to extract its month?

Refer to the date cell (e.g., A2) in MONTH or TEXT, such as MONTH(A2) or TEXT(A2,"mmmm"). This makes your formulas dynamic as dates change or are updated.

Just point MONTH or TEXT at the date cell, and Excel will do the math for you.

What if the workbook uses the 1900 vs 1904 date system?

The 1900 vs 1904 date system can affect date arithmetic. Usually, modern Excel defaults to 1900. If you see unexpected month values after migrating workbooks, check the Date System in Excel Options.

Some old files use different date systems; check the workbook properties if months look off after opening older files.

The Essentials

  • Use MONTH(TODAY()) for current month as a number
  • Use TEXT(TODAY(),"mmmm") for full month name
  • Create a date anchor with DATE(YEAR(A2),MONTH(A2),1) for monthly grouping
  • Use EOMONTH for end-of-month boundaries
  • Locale controls month names with format strings like ["$-409"]mmmm
← More in Excel Formulas & Functions