Skip to content
Excel

MONTH function in Excel

Converts a serial number to a month

=MONTH(serial_number)

MONTH syntax and parameters

One argument, one required.

  • serial_numbernumberRequired

    The date of the month you are trying to find. Dates should be entered by using the DATE function, or as results of other formulas or functions. For example, use DATE(2008,5,23) for the 23rd day of May, 2008. Problems can occur if dates are entered as text.

MONTH examples

Formulas you'll actually reuse.

  1. The month number of an invoice date, for a SUMIFS by month:

    =MONTH(B2)

    Result8

  2. A month label built from the date — for a pivot-style report:

    =TEXT(DATE(2026, MONTH(B2), 1), "mmm yyyy")

    Result"Aug 2026"

MONTH in Google Sheets

Same name — your formula ports as-is.

Try MONTH in the playground

Edit the example — nothing to install.

Preloaded with the MONTH formula from Example 1 — change anything and watch it respond.

Loading the editor…

Related functions

More ways Excel gets this done.