assay
date

year-from-string

Subject
YEAR
Category
value
Formula
=YEAR("2025-03-15")
Canonical
2025

Owning divergences (1)

Per-engine results

matches canonical diverges no fixture

Engine Verdict Value
gsheets match 2025
excel match 2025
lattice match 2025
ironcalc match 2025
hyperformula diverge #VALUE!
libreoffice diverge
formulas match 2025
pycel diverge #VALUE!