Free MONTH Formula Generator

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.

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