YEAR
Gets the year component of the specified date.
Syntax
=YEAR(date)
Arguments
| Argument | Type | Description |
|---|---|---|
| date | Date | The date to use for calculation |
Examples
=YEAR(DATE(2020, 2, 3, 4, 5))→2020
Gets the year component 2020 from the specified date Feb 3, 2020 4:05 AM
=YEAR(DATE(2016, 4, 5, 6, 7))→2016
Gets the year component 2016 from the specified date Apr 5, 2016 6:07 AM
Updated over 1 year ago