Buzz
This article introduces you to the MONTH function, one of the highly favored functions in the date, time, and Excel community.
Description: The function returns the month of a date represented by a serial number in Excel. The month is represented by an integer ranging from 1 to 12.
Syntax: MONTH(serial_number)
In this, serial_number represents the date in serial form for which you want to calculate the month.
Note:
- Excel stores dates in serial form for convenient calculations.
- The return values of YEAR, MONTH, DAY functions are in Gregorian format regardless of the provided display format.
Example:
Calculating the month values for different formatted dates:
- In the cell where you want the result, use the formula: =MONTH(F7).
- Press Enter -> the returned month value is:
- Similarly, replicate the formula for the remaining values to achieve the results:
Here is a guide and some specific examples when working with the MONTH function in Excel.
Wishing you all the best in your endeavors!
