How to extract the year in Excel Introduction to the method of extracting the year in Excel table

How to extract the year in Excel? Recently, a user asked this question. When using an Excel spreadsheet, they want to extract the year from the date. Is there a simple and easy way? In fact, there is. In response to this problem, this article brings detailed operation steps to share with everyone. If you are interested, please continue reading. Introduction to the method of extracting the year from the Excel table: 1. Open the excel table from which the year needs to be extracted.

2. Select the cell to be extracted and enter =YEAR().

3. Fill in the position where the year and date need to be extracted in the brackets (). Take the picture as an example and fill in (A2).

4. Press Enter to get the year of the date.

5. Pull down the extracted years and apply the formula to them all.

6. Even if you add the year, month and day of another year, the year is extracted successfully.

The above is the detailed content of How to extract the year in Excel Introduction to the method of extracting the year in Excel table. For more information, please follow other related articles on the PHP Chinese website!