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:

Picture 1 of MONTH function - The function converts a serial number into a month in Excel

In the cell to calculate enter the formula: MONTH (C7) .

Picture 2 of MONTH function - The function converts a serial number into a month in Excel

Press Enter -> separated month results:

Picture 3 of MONTH function - The function converts a serial number into a month in Excel

Copying the formula to the remaining cells results:

Picture 4 of MONTH function - The function converts a serial number into a month in Excel

If the date entered is wrong, the month exceeds December -> the function returns the #VALUE error value.

Picture 5 of MONTH function - The function converts a serial number into a month in Excel

Above is the usage and some notes when using the MONTH () function .

Good luck!

Update 19 May 2020

You should read it