What does it do?

Gets the year from the date

Formula breakdown:


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


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


YEAR Formula in Excel


STEP 2: The YEAR arguments:


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

Select the cell containing the date:


YEAR Formula in Excel

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

YEAR Formula in Excel

You now have your years extracted!

YEAR Formula in Excel


How to Use the YEAR Formula in Excel



YEAR Formula in Excel | MyExcelOnline



Get access to 30+ Microsoft Excel & Office courses for ONLY $1.

Click here to get this limited-time $1 offer!

Microsoft Excel & Office Online Training Course

If you like this Excel tip, please share itEmail this to someone


Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn