YEAR function


Return the year from a date.



=YEAR( serial_number )


required arguments:

serial_number A date from which to extract the year.

Skillshare’s usually $10 a month, but because you’re an OfficeTuts reader you can get your first month free by clicking here. That’s unlimited access to over 18,000 classes on Excel, VBA, and much more.