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!