YEAR
Purpose
- Provides the year when given a specific date
Example
- Here is a screenshot, for reference:
Syntax
=YEAR(serial_number)
Arguments
- serial_number
- This is the date in question, formatted as a serial number (and you need the year of this date)
- This can be a hard-coded number, cell reference, or calculation