How to use text function to convert date to year

Steps to use the text function date to convert year: 1. Create a new excel document; 2. Select the cell where the year is entered in excel; 3. Enter the formula "=text (cell, "yyyy" in the cell "), click Enter; 4. The year in the date was extracted successfully.

The operating environment of this tutorial: Windows 10 system, office2021 version, Dell g3 computer.

text function date conversion year steps:

1. Select the year cell

Select the cell where the year is entered in excel.

2. Enter the text function

Enter the formula =text (cell, "yyyy") in the cell and click Enter.

3. Conversion successful

The year in the date was extracted successfully.

The above is the detailed content of How to use text function to convert date to year. For more information, please follow other related articles on the PHP Chinese website!