Table of Contents
Summary
The Excel MONTH function returns the month of the year, a number between 1 and 12. The MONTH function is an Excel date and time function.
Function
=MONTH(serial_number)
Arguments (inputs)
serial_number = a number representing a date in Microsoft Excel
Return value
The MONTH function returns the month of the year, a number between 1 and 12.
Example
In the example above the MONTH function returns the month of the year for the date in cell C5.
=MONTH(C5)
The result returned is 6.
