How to Get Month From Date in Excel

Manytimes, we want to extract month from a date. Extracting them manually not a good idea. Excel provides special MONTH function to get month number from a date. Sum times we want to get month name, like Jan, January, etc. That can be done too.

In this article, we will learn How to get numeric month from date and how to get text month from a date.
Context:
Here I have a list of dates. In the columns adjacent to it I want to get numeric month and text month.
008
Getting Month Number From Date In Excel
Excel has MONTH function that retrieves retrieves month from a date in numeric form.
Generic Formula

=MONTH(date)

Date: It is the date from which you want to get month number in excel.

In cell B2, write this formula and copy it down the cells.

=MONTH(A2)

009
We have our month number in column B.
Getting Text Month From Date In Excel
If you want to get month name in excel from a date than use excel TEXT function.

Generic Formula

=TEXT(date, “mmm”)
=TEXT(date, “mmmm”)

The TEXT function is used to specially formate given values. Now let’s see how we can get month names from date in above example.

Write this formula in cell C2 and drag it down the cells.

=TEXT(A2, “mmm”)

This will return the name short month’s name from given date.
0010
If you want full month name then write this formula.

=TEXT(A2, “mmmm”)

0011
Simple, wasn’t it? So yeah guys these are the ways to extract month from date. If you have any query regarding this article or any other excel function, feel free to ask in the comment section below. We are a large community, there’s always someone to solve your Excel/VBA query.

Related Articles:

Calculate Months Between dates in Excel
Get day name from Date in Excel
Vlookup by Date in Excel
SUM if date is between

Popular Articles:
The VLOOKUP Function in Excel
COUNTIF in Excel 2016
How to Use SUMIF Function in Excel

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube