How to Use the Excel Month Function?

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’.

Table of Contents hide

1 Where to Find Date & Time Function?

2 What is Excel Month Function?

3 Syntax

4 Arguments

5 Understand With Example

6 Share this:

7 Related

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:

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).

Syntax

MONTH(serial_number)

Arguments

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.

Note:

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.