How to Extract Month from Date in Excel.
If you’re working with dates in Excel, you may need to extract the month from a date at some point. Fortunately, Excel has a built-in function that makes this task simple and straightforward. Extracting the month from a date is a common task in Excel, and it can be accomplished with a simple Formula. Whether you need the Month Number or the Name of the Month, Excel provides functions that can help you extract the information you need. In this tutorial we learn how to extract Month from Date. Here we have a dataset which contains 9 random dates and we will extract Month Number and Month name from it.
Step 1 – Extracting Month Name.
– For extracting the month name from a date you have to type the formula.
– Syntax of the formula is
=text(Cell_Address_of_date,”mmmm”)
– In our case the cell address of date is A2.
Step 2 – Extracting Month Number
– For extracting the month number from a date you have to type the formula.
– Syntax of the formula is
=text(Cell_Address_of_date,”mm”)
– MONTH Function can also be used for extracting month number, its syntax is
=MONTH(Cell_Address_of_date)
– In our case the cell address of date is A2.
Step 3 – Extracting Month names and numbers for rest of the values.
– Drag the cell B2 (In our case) from bottom right to the rest of the cells to get month names corresponding to given dates.
– Drag the cell C2 (In our case) from bottom right to the rest of the cells to get the month number corresponding to given dates.