The MONTH function in Excel returns the month component of a specified date as a number between 1-12.
Syntax:
=MONTH(serial_number)
Arguments
serial_number – (required) The date that contains the month you want to extract.
MONTH Function Usage Examples:
Let’s look at the following example that shows how the month is removed from a date value in Excel.
Here are some other usage examples. Excel automatically pulls out the month from a date. When other components are present, such as hours, seconds, and days, Excel ignores these figures. Review the example below.
Usage Errors
#VALUE! error – The serial_number is not a valid Excel date.