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

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(

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)

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

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

Checkout more Excel Formulas to increase your skills.