MONTH Formula Generator (2026) — Extract Month from Date | Free Excel & Sheets

Returns the month of a date, a number from 1 (January) to 12 (December).

Generated Formula
=MONTH(date)

Learning Resources

Want to master Excel? Check out this Top-Rated Course.

Common Errors & Fixes

  • MONTH returns wrong value

    Causes:
    • The date cell contains a serial number display issue.
    • The input is text in an unrecognized date format.
    Fixes:
    • Format the date cell properly using Format Cells > Date.
    • Use DATEVALUE() for text dates.

Frequently Asked Questions

Why does MONTH return a number instead of the month name?

MONTH always returns a number (1-12). To show the month name, use TEXT: =TEXT(A1, "MMMM") for full name or "MMM" for abbreviated name.

What does MONTH return for a blank cell?

MONTH returns 1 for a blank cell because Excel treats empty cells as date serial number 0, which corresponds to January 0, 1900 — month 1.

Does MONTH work in Google Sheets?

Yes, MONTH works identically in Google Sheets with the same syntax and behavior.

Related Formulas

DATEDIFNOWTODAYNETWORKDAYSYEAR

Want to become an Excel Pro?

Stop searching for formulas. Master Excel in 30 days with this top-rated course.

Learn More