YEAR
Definition of YEAR
Returns the year specified by a given date.
Sample Usage
YEAR(DATE(1969,7,20))
YEAR(A2)
YEAR(40909)
Syntax
YEAR(date)
date
- The date from which to calculate the year. Must be a cell reference to a cell containing a date, a function returning a date type, or a number.
Notes
- Ensure that the input to the function is either a reference to a cell containing a date, a function which returns a date object such as
DATE
,DATEVALUE
orTO_DATE
, or a date serial number of the type returned by theN
function. YEAR
does not autoconvert number formats in the same way that Google Sheets does upon direct entry into cells. Therefore,YEAR(10/10/2000)
is interpreted asYEAR(0.005)
, the quotient of 10 divided by 10 divided by 2000.
See Also
WEEKDAY
: Returns a number representing the day of the week of the date provided.
TO_DATE
: Converts a provided number to a date.
N
: Returns the argument provided as a number.
MONTH
: Returns the month of the year a specific date falls in, in numeric format.
DAY
: Returns the day of the month that a specific date falls on, in numeric format.
DATEVALUE
: Converts a provided date string in a known format to a date value.
DATE
: Converts a provided year, month, and day into a date.
In order to use the YEAR formula, start with your edited Excellentable:
Then type in the YEAR Formula in the area you would like to display the outcome:
By adding the value you would like to calculate the YEAR formula for, Excellentable will generate the outcome:
A
|
B
|
C
|
D
|
|
---|---|---|---|---|
1
|
||||
2
|
||||
3
|
||||
4
|
||||
5
|
||||
6
|
||||
7
|
||||
8
|
||||
9
|
||||
10
|
||||
11
|
||||
12
|
||||
13
|
||||
14
|
||||
15
|
E
|
F
|
G
|
|
---|---|---|---|
1
|
|||
2
|
|||
3
|
|||
4
|
|||
5
|
|||
6
|
|||
7
|
|||
8
|
|||
9
|
|||
10
|
|||
11
|
|||
12
|
|||
13
|
|||
14
|
|||
15
|