HomeExcel Functions ► Excel Month Function

Syntax For Excel MONTH Function

What is the use Excel Month Function?

Excel Month Function can extract the number of the month from a specified date ranging from 1 to 12.

What Is Excel MONTH Function

In above example, I have used month formula to get the month number from the given date. As January is the first month of the year so, month function returns 1 as month number.

Syntax for Excel Month function

MONTH(serial_number)

serial_number A valid date as per the excel date serial numbers. [Required]

More Information

  • Date from which you want to get the month number should be a valid date.
  • If you mention an invalid date it will return #VALUE! error.
  • if you skip entering any value in serial_number it will return 0.

Examples to understand Excel Month Function

Excel Month Function With Today Function

In above example, I have used month formula along with today function to get the month. It will always give the number of current month whenever date changes.

Excel Month Function With Today Function

In above example, I have used month function along with Choose & Today. This dynamic formula will return the name of the month instead of month number.

You can also use month to create some

Download Sample File

Download Sample File To Learn Excel MONTH Function

More Tips Related With Excel MONTH Function

Conclusion

Excel Month Function can be used to create some dynamic formulas in excel. You can use it with the number of other formulas to get effective results. Learn more about MONTH from here.

Related Functions

Day | Year 

Excel Functions | Excel Formulas