It returns the month of a date, represented by a serial number. The month is given as an integer ranging from 1 to 12.
The syntax of the function is the following:
MONTH(serial_number)
serial_number: the serial number representation of a date
Click on the button to practice using this function, with the help of our Online Assessment Tool:
Here is an example of how to use the MONTH function:
In the cell range B2:D21, insert the appropriate functions so that
column B displays the day of the date appearing in column A,
column C displays the month of the date appearing in column A,
column D to displays the year of the date appearing in column A.