You have an expression containing dates, but you only want to separate the year value for other calculations. Use the Year function in Excel, a simple and easy-to-use function that will help you split the year accurately and quickly.
Syntax: =YEAR(serial_number)
The syntax of YEAR Function in Excel has only one parameter i.e. Serial Number.
- Serial Number: This is the value we giving to extract the Year from the date or serial number. The return value is always between 1900 and 9999.
Example 1: From the below-given dates extract the year values.
Syntax: =YEAR(B2)
Result:
So you already know how to use the YEAR function to split the year value in a data table. In addition, you can refer to the DAY function in Excel, the MONTH function in Excel, … to separate date and month values.