If you need to quickly extract the year from a date in Microsoft Excel, you can use the YEAR function. This will give you the year value in a separate cell, allowing you to use it in a separate formula.
Read This Article on How-To Geek ›
https://bit.ly/2SaYT24
https://bit.ly/2SaYT24