Excel Formulas to Convert Date into Month and Year ~ Simple Solution!!

For example, you have a list of dates, and now you need to extract only the month and year. How could you convert the date into month and year in Excel? This article provides some simple formulas to help you quickly get it done. Let’s get into this article!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

Generic Formula:

• Use the below formula to extract the month and year from the date in Excel.

=TEXT(date,”yyyymmmm”)

Syntax Explanations:

• *TEXT * – In Excel, the **TEXT function **helps you to simplify things when you come across data that has too much text.
• *Date * – It represents the input dates from your worksheet.
• Comma symbol (,) – It is a separator that helps to separate a list of values.
• Parenthesis () – The main purpose of this symbol is to group the elements.

Example:

Let’s consider the below example image.

• First, we will enter the input dates in Column B.
• Now we are going to convert these dates into month and year.

• So, apply the above-given formula to the formula bar section and press the ENTER key.

• Finally, we will get the result in the selected cell.

Wrap-Up:

In this article, we have described the simple formulas to convert the date into month and year in Excel easily. I hope that this article is helpful to you. If you have any issue regarding this article or any unresolved query , please comment in the comment box below. We will assist you. Thank you. Click here to know more about *Geek Excel **and Excel Formulas *!! **

Read Ahead:

• Excel Formulas to Calculate the Years Between Dates ~ Simple Tricks!!
• How to Highlight All Errors Using Macros (VBA) In Excel Office 365?
• What is a Name Box and Its Features in Microsoft Excel 365?
• Excel Formulas to Convert date into Julian’s Date Format [Simple Tricks]