How to extract year and month from date in excel?

To extract the MONTH and YEAR from the date in excel, you can use the year function to extract the year, the month function to extract the month, and then use the merge function "&". Just combine the years and months.

The method comprises the following steps:

1. Open the EXCEL table to be operated, enter "= year" in the function edit box above any blank cell, and then click to select the cell to extract the year.

2. Continue to enter ")&in the function edit box-"&; Month ("), and then continue to click on the cell that needs to extract the month, and then continue to enter") ",end the formula editing and press enter.

3. Returning to the excel table, we can find that the dates in EXCEL were successfully extracted at the same time.