date

`year-from-date`

Subject: YEAR
Category: value
Formula: =YEAR(DATE(1999, 12, 31))
Canonical: 1999

Per-engine results

matches canonical diverges no fixture

Engine	Verdict	Value
gsheets	match	[object Object]
excel	match	[object Object]
lattice	match	1999
ironcalc	match	1999
hyperformula	match	1999
libreoffice	diverge	—
formulas	match	1999
pycel	match	1999