Google Sheets reference

MONTH in Google Sheets

Works in Google Sheets1 worked example

Worked examples (1)

These formulas work in Google Sheets with identical syntax.

Date & Timebeginner

=YEAR(A2)&"-"&TEXT(MONTH(A2),"00")

Also in Excel

See the full MONTH reference for Excel — including all worked examples, common errors, and FAQ.