How to extract the year in Excel Introduction to the method of extracting the year in Excel table-Computer Software-php.cn

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

PHPz

Release： 2024-08-29 09:35:21

Original

346 people have browsed it

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.

Excel怎么提取年份 Excel表格提取年份的方法介绍

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

Excel怎么提取年份 Excel表格提取年份的方法介绍

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).

Excel怎么提取年份 Excel表格提取年份的方法介绍

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

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

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

Excel怎么提取年份 Excel表格提取年份的方法介绍

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

Excel怎么提取年份 Excel表格提取年份的方法介绍

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!