20
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

=YEAR(date)
Let’s consider the below example image.



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 *!! **
20