Definition of YEAR
Returns the year specified by a given 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.
- 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
TO_DATE, or a date serial number of the type returned by the
YEARdoes not autoconvert number formats in the same way that Google Sheets does upon direct entry into cells. Therefore,
YEAR(10/10/2000)is interpreted as
YEAR(0.005), the quotient of 10 divided by 10 divided by 2000.
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: