DV-0012

hyperformula: different error code — DATEDIF, DATEVALUE, DAYS (+8 more)

Cause: error-code
Category: value
Diverging engines: hyperformula
Behavior signature: {"error":"#VALUE!"}
Test count: 35
Seeded: 2026-04-25
Last confirmed: 2026-04-25

Subjects (11)

DATEDIF DATEVALUE DAYS DAYS360 ISOWEEKNUM NETWORKDAYS NETWORKDAYS.INTL SPLIT WEEKNUM WORKDAY WORKDAY.INTL

Tests (35)

matches canonical diverges no fixture in this DV's cluster

Test	Formula	Canonical	gsheets	excel	lattice	ironcalc	hyperformula	libreoffice	formulas	pycel
`DATEDIF/datedif-years`	`=DATEDIF("2020-01-15", "2025-03-20", "Y")`	5	gsheets5	excel5	lattice5	ironcalc5	hyperformula#VALUE!	libreoffice—	formulas5	pycel#NAME?
`DATEDIF/datedif-months`	`=DATEDIF("2020-01-15", "2025-03-20", "M")`	62	gsheets62	excel62	lattice62	ironcalc62	hyperformula#VALUE!	libreoffice—	formulas62	pycel#NAME?
`DATEDIF/datedif-days`	`=DATEDIF("2025-01-01", "2025-02-01", "D")`	31	gsheets31	excel31	lattice31	ironcalc31	hyperformula#VALUE!	libreoffice—	formulas31	pycel#NAME?
`DATEDIF/datedif-md-day-only`	`=DATEDIF("2020-01-15", "2025-03-20", "MD")`	5	gsheets5	excel5	lattice5	ironcalc5	hyperformula#VALUE!	libreoffice—	formulas5	pycel#NAME?
`DATEDIF/datedif-ym-month-only`	`=DATEDIF("2020-01-15", "2025-03-20", "YM")`	2	gsheets2	excel2	lattice2	ironcalc2	hyperformula#VALUE!	libreoffice—	formulas2	pycel#NAME?
`DATEVALUE/datevalue-iso`	`=DATEVALUE("2025-03-15")`	45731	gsheets45731	excel45731	lattice45731	ironcalc45731	hyperformula#VALUE!	libreoffice—	formulas45731	pycel45731
`DAYS/days-basic`	`=DAYS("2025-03-15", "2025-03-01")`	14	gsheets14	excel14	lattice14	ironcalc14	hyperformula#VALUE!	libreoffice—	formulas14	pycel#NAME?
`DAYS/days-negative`	`=DAYS("2025-03-01", "2025-03-15")`	-14	gsheets-14	excel-14	lattice-14	ironcalc-14	hyperformula#VALUE!	libreoffice—	formulas-14	pycel#NAME?
`DAYS/days-same-day`	`=DAYS("2025-03-15", "2025-03-15")`	0	gsheets0	excel0	lattice0	ironcalc0	hyperformula#VALUE!	libreoffice—	formulas0	pycel#NAME?
`DAYS/days-across-year`	`=DAYS("2025-01-01", "2024-01-01")`	366	gsheets366	excel366	lattice366	ironcalc366	hyperformula#VALUE!	libreoffice—	formulas366	pycel#NAME?
`DAYS360/days360-basic`	`=DAYS360("2025-01-15", "2025-03-15")`	60	gsheets60	excel60	lattice60	ironcalc60	hyperformula#VALUE!	libreoffice—	formulas60	pycel#NAME?
`DAYS360/days360-full-year`	`=DAYS360("2024-01-01", "2025-01-01")`	360	gsheets360	excel360	lattice360	ironcalc360	hyperformula#VALUE!	libreoffice—	formulas360	pycel#NAME?
`DAYS360/days360-european-method`	`=DAYS360("2025-01-31", "2025-03-31", TRUE)`	60	gsheets60	excel60	lattice60	ironcalc60	hyperformula#VALUE!	libreoffice—	formulas60	pycel#NAME?
`ISOWEEKNUM/isoweeknum-mid-year`	`=ISOWEEKNUM("2025-06-15")`	24	gsheets24	excel24	lattice24	ironcalc24	hyperformula#VALUE!	libreoffice—	formulas24	pycel#NAME?
`ISOWEEKNUM/isoweeknum-jan-1-belongs-to-prev-year`	`=ISOWEEKNUM("2023-01-01")`	52	gsheets52	excel52	lattice52	ironcalc52	hyperformula#VALUE!	libreoffice—	formulas52	pycel#NAME?
`ISOWEEKNUM/isoweeknum-first-week`	`=ISOWEEKNUM("2024-01-01")`	1	gsheets1	excel1	lattice1	ironcalc1	hyperformula#VALUE!	libreoffice—	formulas1	pycel#NAME?
`NETWORKDAYS/networkdays-basic-week`	`=NETWORKDAYS("2025-03-03", "2025-03-07")`	5	gsheets5	excel5	lattice5	ironcalc5	hyperformula#VALUE!	libreoffice—	formulas5	pycel#NAME?
`NETWORKDAYS/networkdays-across-weekend`	`=NETWORKDAYS("2025-03-07", "2025-03-10")`	2	gsheets2	excel2	lattice2	ironcalc2	hyperformula#VALUE!	libreoffice—	formulas2	pycel#NAME?
`NETWORKDAYS/networkdays-reversed`	`=NETWORKDAYS("2025-03-07", "2025-03-03")`	-5	gsheets-5	excel-5	lattice-5	ironcalc-5	hyperformula#VALUE!	libreoffice—	formulas-5	pycel#NAME?
`NETWORKDAYS.INTL/networkdays-intl-default-weekend`	`=NETWORKDAYS.INTL("2025-03-03", "2025-03-07", 1)`	5	gsheets5	excel5	lattice5	ironcalc5	hyperformula#VALUE!	libreoffice—	formulas5	pycel#NAME?
`NETWORKDAYS.INTL/networkdays-intl-numeric-weekend-sun-only`	`=NETWORKDAYS.INTL("2025-03-03", "2025-03-09", 11)`	6	gsheets6	excel6	lattice6	ironcalc6	hyperformula#VALUE!	libreoffice—	formulas6	pycel#NAME?
`NETWORKDAYS.INTL/networkdays-intl-string-weekend-fri-sat`	`=NETWORKDAYS.INTL("2025-03-03", "2025-03-09", "0000011")`	5	gsheets5	excel5	lattice5	ironcalc5	hyperformula#VALUE!	libreoffice—	formulas5	pycel#NAME?
`NETWORKDAYS.INTL/networkdays-intl-string-weekend-custom`	`=NETWORKDAYS.INTL("2025-03-03", "2025-03-09", "0000001")`	6	gsheets6	excel6	lattice6	ironcalc6	hyperformula#VALUE!	libreoffice—	formulas6	pycel#NAME?
`WEEKNUM/weeknum-default`	`=WEEKNUM("2025-01-05")`	2	gsheets2	excel2	lattice2	ironcalc2	hyperformula#VALUE!	libreoffice—	formulas2	pycel#NAME?
`WEEKNUM/weeknum-monday-start`	`=WEEKNUM("2025-01-05", 2)`	1	gsheets1	excel1	lattice1	ironcalc1	hyperformula#VALUE!	libreoffice—	formulas1	pycel#NAME?
`WORKDAY/workday-forward`	`=WORKDAY("2025-03-03", 5)`	45726	gsheets45726	excel45726	lattice45726	ironcalc45726	hyperformula#VALUE!	libreoffice—	formulas45726	pycel#NAME?
`WORKDAY/workday-backward`	`=WORKDAY("2025-03-10", -5)`	45719	gsheets45719	excel45719	lattice45719	ironcalc45719	hyperformula#VALUE!	libreoffice—	formulas45719	pycel#NAME?
`WORKDAY/workday-zero-offset`	`=WORKDAY("2025-03-03", 0)`	45719	gsheets45719	excel45719	lattice45719	ironcalc45719	hyperformula#VALUE!	libreoffice—	formulas45719	pycel#NAME?
`WORKDAY.INTL/workday-intl-default-weekend`	`=WORKDAY.INTL("2025-03-03", 5, 1)`	45726	gsheets45726	excel45726	lattice45726	ironcalc45726	hyperformula#VALUE!	libreoffice—	formulas45726	pycel#NAME?
`WORKDAY.INTL/workday-intl-numeric-weekend-fri-sat`	`=WORKDAY.INTL("2025-03-03", 5, 7)`	45726	gsheets45726	excel45726	lattice45726	ironcalc45726	hyperformula#VALUE!	libreoffice—	formulas45726	pycel#NAME?
`WORKDAY.INTL/workday-intl-string-weekend`	`=WORKDAY.INTL("2025-03-03", 5, "0000011")`	45726	gsheets45726	excel45726	lattice45726	ironcalc45726	hyperformula#VALUE!	libreoffice—	formulas45726	pycel#NAME?
`WORKDAY.INTL/workday-intl-sunday-only-string`	`=WORKDAY.INTL("2025-03-03", 5, "0000001")`	45724	gsheets45724	excel45724	lattice45724	ironcalc45724	hyperformula#VALUE!	libreoffice—	formulas45724	pycel#NAME?
`SPLIT/split-comma`	`=SPLIT("a,b,c", ",")`	{a, b, c}	gsheets{a, b, c}	excel—	lattice{a, b, c}	ironcalc#NAME?	hyperformula#VALUE!	libreoffice—	formulas#NAME?	pycel#NAME?
`SPLIT/split-multi-delim`	`=SPLIT("a-b_c", "-_")`	{a, b, c}	gsheets{a, b, c}	excel—	lattice{a, b, c}	ironcalc#NAME?	hyperformula#VALUE!	libreoffice—	formulas#NAME?	pycel#NAME?
`SPLIT/split-single-token`	`=SPLIT("hello", ",")`	hello	gsheetshello	excel—	latticehello	ironcalc#NAME?	hyperformula#VALUE!	libreoffice—	formulas#NAME?	pycel#NAME?