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

50 Excel Shortcut to Increase Your Productivity: Get faster at your task. These 50 shortcuts will make you work even faster on Excel.

How to use the VLOOKUP Function in Excel: This is one of the most used and popular functions of excel that is used to lookup value from different ranges and sheets.

How to use the COUNTIF function in Excel: Count values with conditions using this amazing function. You don't need to filter your data to count specific values. Countif function is essential to prepare your dashboard.

How to use the SUMIF Function in Excel: This is another dashboard essential function. This helps you sum up values on specific conditions.

Leave a Reply

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

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.