# Get year from date

=YEAR(date)

If you need to extract the year from a date, you can use the YEAR function. In the generic form of the formula above, the date must be in a form that Excel recognizes as a valid date.

The YEAR function takes just one argument, the date from which you want to extract the year. In the example, the formula is:

=YEAR(B4)

B4 contains a date value for January 5, 2016. The YEAR function returns the number 2016 representing the year of the date.

Note that you can use YEAR to extract the year from a day entered as text:

=YEAR("1/5/2016")

However, using text for dates can cause unpredictable results on computers using different regional date settings. In general it's better (and more flexible) to supply an address to a cell that already contains a valid date.

### Display only year

If you want to enter a date and only display the year, you can apply a custom number format like "yyyy" or "yy".

## Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.

## Download 100+ Important Excel Functions

Get over 100 Excel Functions you should know in one handy PDF.