MONTH function - The function converts a serial number into a month in Excel
MONTH function: Function performs month value separation in a specific date time month. The return month value is an integer between 1 and 12..
The following article details how to use the MONTH function, the function converts a serial number into a month in Excel.
Description: The function separates month values in a specific date time. The return month value is an integer between 1 and 12.
Syntax : MONTH (serial_number) .
Inside:
serial_number is the date and month we want to separate the month.
For example:
Separate month values from the following dates:
In the cell to calculate enter the formula: MONTH (C7) .
Press Enter -> separated month results:
Copying the formula to the remaining cells results:
If the date entered is wrong, the month exceeds December -> the function returns the #VALUE error value.
Above is the usage and some notes when using the MONTH () function .
Good luck!
Lesley Montoya