YEAR function

YEAR returns the year as a number according to the internal calculation rules.



number shows the internal date value for which the year is to be returned.


=YEAR(1) returns 1899 as 1 corresponds to 12/31/1899.

=YEAR(367) returns 1901 as 367 corresponds to 1/1/1901.

Note: The goal is for HCL Connections Docs to be as accurate and as compatible with Microsoft Excel as possible. Therefore, starting from 1/1/1900, or the numeric value greater than 1, there is no difference between the two applications.