MONTH function - The function returns the monthly value of a day expressed as a serial number in Excel

MONTH function: The function returns the month of a day expressed as serial number in Excel. Months are represented by integers with values ​​between 1 and 12 months. Syntax: MONTH (serial_number)

The following article introduces you to the MONTH function - one of the functions in the date and time group is very popular in Excel.

MONTH function - The function returns the monthly value of a day expressed as a serial number in Excel Picture 1MONTH function - The function returns the monthly value of a day expressed as a serial number in Excel Picture 1

Description: The function returns the month of a day expressed as serial number in Excel. Months are represented by integers with values ​​between 1 and 12 months.

Syntax: MONTH (serial_number)

Where serial_number is the date denoted by the serial number you want to calculate the month value.

Attention:

- Excel stores the date as a serial number to facilitate the calculation process.

- The return value of the function YEAR, MONTH, DAY is a Gregorian value regardless of the display format provided.

For example:

Calculate monthly values ​​in days with different formats:

MONTH function - The function returns the monthly value of a day expressed as a serial number in Excel Picture 2MONTH function - The function returns the monthly value of a day expressed as a serial number in Excel Picture 2

- In the cell to calculate enter the formula: = MONTH (F7).

MONTH function - The function returns the monthly value of a day expressed as a serial number in Excel Picture 3MONTH function - The function returns the monthly value of a day expressed as a serial number in Excel Picture 3

- Press Enter -> return month value is:

MONTH function - The function returns the monthly value of a day expressed as a serial number in Excel Picture 4MONTH function - The function returns the monthly value of a day expressed as a serial number in Excel Picture 4

- Similarly copying the formula for the remaining values ​​results:

MONTH function - The function returns the monthly value of a day expressed as a serial number in Excel Picture 5MONTH function - The function returns the monthly value of a day expressed as a serial number in Excel Picture 5

Above are instructions and some specific examples when working with the MONTH function in Excel.

Good luck!

4 ★ | 2 Vote