how to change date format in excel to year only?
Select a blank cell adjacent to the cell you want to display year of date only, and then type formula =YEAR(A1) into the Formula Bar, and then press the Enter key to get the result. See screenshot: 2. Drag the Fill Handle down to the range until all years of reference dates displaying in the cells.