Extracting the Year from a Date Field
The worksheet below contains dates in column A. The user needs to have the year display in column B.
In cell B1, type the formula: =Year(A1)
Press Enter
Use Autofill to copy the formula to the rest of the cells.
