assay
date

daf9af

Subject
YEARFRAC
Category
value
Formula
=YEARFRAC("2025-01-01", "2026-01-01", 2)
Canonical

Per-engine results

matches canonical diverges no fixture

Engine Verdict Value
gsheets diverge 1.01389
excel diverge 1.01389
lattice diverge 1.01389
ironcalc diverge 1.013888889
hyperformula diverge #VALUE!
libreoffice diverge 1.01389
formulas diverge 1.01389
pycel diverge #VALUE!