YEAR
Description
Returns an integer from 1900-9999 representing only the year specified in the date.
Syntax
YEAR(
date
)
- date: The date to get the year value from. Workday recommends entering a serial date or using a cell reference to specify the date instead of entering the date as text, to ensure reliable results.
Example
Formula | Result |
|---|---|
=YEAR("12/31/2016 5:37 PM") | 2016 |
=YEAR("31-Dec-2016") | 2016 |