In the previous post, we saw ‘Date & Time Function | How to Use the Excel NOW Function?‘, now we will learn about ‘How to Use the Excel Month Function’.

Where to Find Date & Time Function?

To find the Date & Time function in excel open excel and click on the “Blank” to open a blank excel worksheet now click on the ‘Formula Tab’ and under ‘Function Library’ click on the ‘Date & Time’ option as shown below:

Date & Time Excel function, Month excel

What is Excel Month Function?

The Excel Month function Returns the month of a date represented by a serial number. The month is given as an integer, ranging from 1 (January) to 12 (December).




The MONTH function syntax has the following arguments:

Serial_number    Required. The date of the month you are trying to find. Dates should be entered by using the DATE function, or as results of other formulas or functions. For example, use DATE(2021,5,23) for the 23rd day of May, 2021. Problems can occur if dates are entered as text.


Excel stores dates as sequential serial numbers so they can be used in calculations.

By default, January 1, 1900 is serial number 1, and January 1, 2008 is serial number 39448 because it is 39,448 days after January 1, 1900.

Understand With Example

Month function excel

Type =MONTH(B5) and select the cell -it will Return the month of a date represented by a serial number.

For Latest Updates & Learning Join Our YouTube Channel: Join Now