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:

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

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

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

Press Enter -> separated month results:

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

Copying the formula to the remaining cells results:

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

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

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

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

Good luck!

5 ★ | 2 Vote