YEAR

Formula Explanation

Returns the year corresponding to a given date. The year is returned as an integer between 1900 and 9999.

Formula Syntax

In the result column, enter: YEAR(column_number)

The YEAR function syntax has the following argument:

• The date should be entered using the DATE function or as the result of another formula or function.
  • For example, use the function DATE(2008,5,23) to input May 23, 2008.
  • If the date is entered as text, there may be issues.

Usage Example

Write the year from column FE2 into column FE3.

FE3 = year(FE2)

✉️ Ask Tablize