## YEAR Formula in Excel

If you can recall where you were having a lot of dates and wanted to extract the year of the dates, that creates too much of hassle; right? Do not worry about this now because now there is an Excel’s **YEAR Formula** which will help you to do this without any hassle.

**Year Formula breakdown **is written below**:**

`=YEAR(serial_number)`

**The explanation for the formula:**

`=YEAR(the date from where you need to extract the year)`

Previously In Excel Formulas:How to use the WEEKNUM Formula in Excel?

**All the steps are explained below:**

## STEP1. Firstly, you need to enter the Year function in a blank cell of your Excel e.g.

`=YEAR( `

## STEP2. In second step continue with the Year arguments e.g.

**Serial_number**

In the place of serial_number you have to select the cell that contains the date:

`=YEAR(A2)`

By dragging the lower right corner downwards apply the same formula to the other cells.

You now have your result.