What does it do?

Gets the month from the date

Formula breakdown:

=MONTH(serial_number)

What it means:

=MONTH(date wherein the month will be extracted from)


I recall wherein I had a lot of dates and I wanted to extract the month of the dates one-by-one… It was too much of a hassle! Thankfully there is Excel’s MONTH Formula to do that for me!

I explain how you can do this below:

DOWNLOAD EXCEL WORKBOOK

STEP 1: We need to enter the MONTH function in a blank cell:

=MONTH(

MONTH Formula in Excel

 

STEP 2: The MONTH arguments:

serial_number

What is the date that you want to extract the month from?

Select the cell containing the date:

=MONTH(C9)

MONTH Formula in Excel

Apply the same formula to the rest of the cells by dragging the lower right corner downwards.

MONTH Formula in Excel

You now have your months extracted!

MONTH Formula in Excel

 

How to Use the MONTH Formula in Excel

HELPFUL RESOURCE:

 

 

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Related Excel Tutorials