Description
Used to return the number year in a Four (4) digit number form. The Year function can be useful in various nested functions and can provide input for functions while excel modeling.
=YEAR(serial_number)
The YEAR function syntax has the following argument:
- Serial_Number Required.
The date of the year you are trying to find.
Note: Avoid directly punching dates into Excel function, instead of either use DATE function or put date within inverted commas (“”) in this sequence i.e. Month/date/year. Otherwise excel will read the date as ZERO.
