How to Extract Year from Date in Excel (3 Ways)

We have a dataset that includes player names and their dates of birth. We want to extract the year from the dates.

Method 1 – Inserting the YEAR Function to Extract the Year from a Date in Excel

Steps

=YEAR(C5)

We put cell C5 because we want to extract the year from this particular cell.

Drag the Fill Handle icon to the last cell where you want to put the extracted year. We get all the extracted year values.

Steps

=TEXT(C5,”yyyy”)

C5 denotes the cell value and yyyy denotes the format text. Excel recognizes this as the format for years.

Press Enter and you’ll get the required year value.
Drag the Fill Handle icon to the last cell where you want to extract the year value for the respective cells.

Excel has 4 different ways to open Format Cells.

Keyboard Shortcut:

Press Ctrl + 1, and the Format cells box will pop up.

Format Cells Option:

Select the text from which you want to extract years, right-click on the selected text cell, and select Format cells.

From Home Tab:

In the Home tab, there is a Cells section where you can choose the Format option.

From the Number section:

Select Format from the Number group in the Home tab.

Steps

Select the data from which you want to extract the year and copy it to another column. We copied the range of cells C5:C10 and pasted it into the range of cells D5:D10.

Open Format Cells. We did it through the Number section from the Home. In the Number section, there is a small arrow at the bottom. Click on it and the Format Cells window will pop up.