Excel Formulas to Extract the Year From Given Date ~ Quick Tricks!!

So far we have learned how to separate the dates and months from the given date. Now we are going to see the formulas to extract the year from the given date in Excel. Let’s get into this article!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

General Formula:

Use the below formula to separate the year from the given date in Excel.

Syntax Explanations:

YEAR – In Excel, the YEAR function will help to extract the year from the given date and returns the year as a 4-digit number.

Date – It specifies the input ranges from your worksheet.

Parenthesis () – The main purpose of this symbol is to group the elements.

Practical Example:

Let’s consider the below example image.

Here, we will enter the input dates in Column B.

Now, we are going to find the year from these dates.

Select any cell and type the above-given formula.

Finally, press ENTER to get the result out, if you need, drag the fill handle over range to apply the formula.

Verdict:

Hope you like this article on how to extract the year from a given date in Excel. Please feel free to state your query or feedback for the above article.

Thank you so much for visiting *Geek Excel!! **If you want to learn more helpful formulas, check out Excel Formulas *!! **

Read Also:

Excel Formulas to Calculate the Work Hours between Dates and Times!!

Excel Formulas to Calculate the Total Working Hours Between Two Dates!!

How to Enter Today’s Date With Time in Excel? Using Shortcuts!!

Excel Formulas to Find the Same Date in Next Year ~ Simple Guide!!