YEAR Function

Originally published at: How to use the YEAR Function in Excel - Excelbuddy.com

The YEAR function in Excel returns a 4-digit number representing the year component of date. This function allows you to pull out the year from a date or use the year in a formula. Syntax: =YEAR(serial_number) Arguments: serial_number – A valid excel date that is referenced to extract the year. Year Function Usage Example In…