The following article introduces you to the MONTH function - one of the functions in the date and time group is very popular in Excel.
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:
- In the cell to calculate enter the formula: = MONTH (F7).
- Press Enter -> return month value is:
- Similarly copying the formula for the remaining values results:
Above are instructions and some specific examples when working with the MONTH function in Excel.
Good luck!