YEAR
Use the YEAR function to return the year from a Date
or Date/Time
. The year is a number ranging from 1000 to 9999.
Use
YEAR( date )
Returns the year of a date or date/time value.
Parameter | Required | Description |
---|---|---|
date | Yes | the date or date/time that contains the year to return |
Returns | Number |
Example
This section isn’t ready just yet—we’re working on it! Please check back soon, and if you need help right away, feel free to ask in our Community Forum.