Description
Returns the year of the given Date.
Syntax
YEAR(Date)
Arguments
Argument | Type | Dimensions | Description |
---|---|---|---|
Date (required) | Date | Any Dimensions | Date to get the year from. |
Returns
Type | Dimensions |
---|---|
Integer | Dimensions of argument Date |
Examples
Formula | Result | Description |
---|---|---|
| 2020 | The date December 2nd 2020 has a year of 2020. |
See also
Excel: YEAR
More of a hands-on learner?
Talk to your Customer Success Manager about downloading the Functions and Modifiers in Pigment Application into your workspace. It includes examples of every formula and modifier in Pigment!