MONTH Formula in Excel

What is the month formula in Excel?

It provides the month from a date with a simple formula. The formula is written below:

=MONTH(serial_number)

It means; =MONTH (Cell number wherein the month will extract from)

In case you want to find a month of the dates but there are lots of date with numbers which is a big hassle for you, then this month formula is going to be a gem for you. I remember my struggle to extract a month from lots of dates it was terrific and time confusing process so, here I am going to share month formula of excel to ease your work as it helped me too.

Follow the steps to apply month formula in your system’s excel:

STEP1. First, in a blank cell, you need to enter the month function. Like this =MONTH(

How to get Month number from a date With A MONTH Formula 1

STEP2. Now continue with month arguments:

SERIAL_NUMBER

Now you must be wondering what to put in this place. First, clear its which date you want to extract the month from. Then select the cell containing that date:

=MONTH(A2)

How to get Month number from a date With A MONTH Formula 2

Now continue with applying the same formula to the remaining cells by dragging the lower right corner downwards.

How to get Month number from a date With A MONTH Formula 3

Finally, here you have your results. Your month will be extracted. 

How to get Month number from a date With A MONTH Formula 4

Checkout more Excel Formulas to increase your skills.