YEAR function in Excel returns the four digit year when date is given as an input. Excel YEAR Function takes date input in the form of
- Reference to cells containing dates
- Date Serial numbers
- Date values returned from other Excel formulas
- Date as a text input
Syntax for YEAR Function in Excel
YEAR (date)
date – A date from which year is extracted
Example of YEAR Function in Excel
Formula:
- Row number 2 and 3 are Reference to cells containing dates
- Row number 4 is date serial number
- Row number 5, the date is given as a text input
- Row number 6,the date values are returned from DATE Formula