Pinterest Pixel

YEAR Formula in Excel

  What does it do? Gets the year from the date Formula breakdown: =YEAR(serial_number) What it means:... read more

Download Excel Workbook
Bryan
Posted on

Steps To Follow

Overview

YEAR Formula in Excel | MyExcelOnline YEAR Formula in Excel | MyExcelOnline

 

What does it do?

Gets the year from the date

Formula breakdown:

=YEAR(serial_number)

What it means:

=YEAR(date wherein the year will be extracted from)


I recall wherein I had a lot of dates and I wanted to extract the year of the dates one-by-one… It was too much of a hassle! Thankfully there is Excel’s YEAR Formula to do that for me!

I explain how you can do this below:

YEAR Formula in Excel | MyExcelOnline

Download excel workbookYEAR-FORMULA.xlsx

STEP 1: We need to enter the YEAR function in a blank cell:

=YEAR(

DAY Formula in Excel

 

STEP 2: The YEAR arguments:

serial_number

What is the date that you want to extract the year from?

Select the cell containing the date:

=YEAR(C9)

DAY Formula in Excel

Apply the same formula to the rest of the cells by dragging the lower right corner downwards.

DAY Formula in Excel

You now have your years extracted!

DAY Formula in Excel

 

How to Use the YEAR Formula in Excel

See also  CHOOSE Formula in Excel

 

 

YEAR Formula in Excel | MyExcelOnline

 

If you like this Excel tip, please share it
YEAR Formula in Excel | MyExcelOnline YEAR Formula in Excel | MyExcelOnline
YEAR Formula in Excel | MyExcelOnline
Bryan

Bryan is a best-selling book author of the 101 Excel Series paperback books.

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...