YEAR
Formulas / YEARRetrieve the year from a date.
YEAR(serial_number)
- serial_number - required argument to find a date
Examples
=YEAR("23-Aug-2012")The YEAR function is used to return the year portion of a given date. To illustrate this, let's look at the example above. This would return the year 2012.
=YEAR(A1)Another example is to use the YEAR function with a cell reference. Suppose cell A1 contains the date "11-May-2019". This can be used in the YEAR, and would return the year 2019.
=DATE(YEAR(A1),1,1)The YEAR function can also be used in the DATE function to return the first day of the year. This can be done by using the YEAR function as an argument in the DATE function, as seen in the example . This would return the first day of the same year as the date given in cell A1.
Summary
The YEAR function returns the year from a given date. This date should be entered using the DATE function and Sourcetable calculates the date as a sequential serial number.
- The YEAR function can be used to extract a year number from a date into a column and feed that value into another formula. The DATE function can be used with the YEAR function to get a month number from a date.
Frequently Asked Questions
What is the YEAR function?
What does the YEAR function do?
What are some examples of using the YEAR function?
What are some other uses of the YEAR function?
- The YEAR function can be used to compare two dates and calculate the difference in years.
- The YEAR function can be used to compare two dates and determine if they are in the same year.
- The YEAR function can be used to filter data by year.
