The YEAR function

Returns the year of a date as a number.

Syntax

YEAR(serial_number)

C1=YEAR(A2)

	A	B	C
1	Date		2024
2	45366

C1=YEAR(A2)-YEAR(DATE(1990,6,1))

	A	B	C
1	Date		34
2	45366