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
date/1f9dec =DATEDIF("2020-01-15", "2025-03-20", "Y") 5 gsheets5 excel5 lattice5 ironcalc5 hyperformula#VALUE! libreoffice5 formulas5 pycel#NAME?
date/1562bb =DATEDIF("2020-01-15", "2025-03-20", "M") 62 gsheets62 excel62 lattice62 ironcalc62 hyperformula#VALUE! libreoffice62 formulas62 pycel#NAME?
date/1b8fd4 =DATEDIF("2025-01-01", "2025-02-01", "D") 31 gsheets31 excel31 lattice31 ironcalc31 hyperformula#VALUE! libreoffice31 formulas31 pycel#NAME?
date/a701fe =DATEDIF("2020-01-15", "2025-03-20", "MD") 5 gsheets5 excel5 lattice5 ironcalc5 hyperformula#VALUE! libreoffice5 formulas5 pycel#NAME?
date/6ab08d =DATEDIF("2020-01-15", "2025-03-20", "YM") 2 gsheets2 excel2 lattice2 ironcalc2 hyperformula#VALUE! libreoffice2 formulas2 pycel#NAME?
date/53e9f1 =DATEVALUE("2025-03-15") 45731 gsheets45731 excel45731 lattice45731 ironcalc45731 hyperformula#VALUE! libreoffice45731 formulas45731 pycel45731
date/85991c =DAYS("2025-03-15", "2025-03-01") 14 gsheets14 excel14 lattice14 ironcalc14 hyperformula#VALUE! libreoffice#NAME? formulas14 pycel#NAME?
date/393422 =DAYS("2025-03-01", "2025-03-15") -14 gsheets-14 excel-14 lattice-14 ironcalc-14 hyperformula#VALUE! libreoffice#NAME? formulas-14 pycel#NAME?
date/f5d649 =DAYS("2025-03-15", "2025-03-15") 0 gsheets0 excel0 lattice0 ironcalc0 hyperformula#VALUE! libreoffice#NAME? formulas0 pycel#NAME?
date/c7c68c =DAYS("2025-01-01", "2024-01-01") 366 gsheets366 excel366 lattice366 ironcalc366 hyperformula#VALUE! libreoffice#NAME? formulas366 pycel#NAME?
date/a3d5e9 =DAYS360("2025-01-15", "2025-03-15") 60 gsheets60 excel60 lattice60 ironcalc60 hyperformula#VALUE! libreoffice60 formulas60 pycel#NAME?
date/ea35c8 =DAYS360("2024-01-01", "2025-01-01") 360 gsheets360 excel360 lattice360 ironcalc360 hyperformula#VALUE! libreoffice360 formulas360 pycel#NAME?
date/d5f0be =DAYS360("2025-01-31", "2025-03-31", TRUE) 60 gsheets60 excel60 lattice60 ironcalc60 hyperformula#VALUE! libreoffice60 formulas60 pycel#NAME?
date/2bf6ea =ISOWEEKNUM("2025-06-15") 24 gsheets24 excel24 lattice24 ironcalc24 hyperformula#VALUE! libreoffice#NAME? formulas24 pycel#NAME?
date/8b84e8 =ISOWEEKNUM("2023-01-01") 52 gsheets52 excel52 lattice52 ironcalc52 hyperformula#VALUE! libreoffice#NAME? formulas52 pycel#NAME?
date/e16816 =ISOWEEKNUM("2024-01-01") 1 gsheets1 excel1 lattice1 ironcalc1 hyperformula#VALUE! libreoffice#NAME? formulas1 pycel#NAME?
date/6f97b2 =NETWORKDAYS("2025-03-03", "2025-03-07") 5 gsheets5 excel5 lattice5 ironcalc5 hyperformula#VALUE! libreoffice5 formulas5 pycel#NAME?
date/bb9294 =NETWORKDAYS("2025-03-07", "2025-03-10") 2 gsheets2 excel2 lattice2 ironcalc2 hyperformula#VALUE! libreoffice2 formulas2 pycel#NAME?
date/10c040 =NETWORKDAYS("2025-03-07", "2025-03-03") -5 gsheets-5 excel-5 lattice-5 ironcalc-5 hyperformula#VALUE! libreoffice-5 formulas-5 pycel#NAME?
date/9f3714 =NETWORKDAYS.INTL("2025-03-03", "2025-03-07", 1) 5 gsheets5 excel5 lattice5 ironcalc5 hyperformula#VALUE! libreoffice5 formulas5 pycel#NAME?
date/f72cc6 =NETWORKDAYS.INTL("2025-03-03", "2025-03-09", 11) 6 gsheets6 excel6 lattice6 ironcalc6 hyperformula#VALUE! libreoffice6 formulas6 pycel#NAME?
date/340cf7 =NETWORKDAYS.INTL("2025-03-03", "2025-03-09", "0000011") 5 gsheets5 excel5 lattice5 ironcalc5 hyperformula#VALUE! libreoffice5 formulas5 pycel#NAME?
date/094014 =NETWORKDAYS.INTL("2025-03-03", "2025-03-09", "0000001") 6 gsheets6 excel6 lattice6 ironcalc6 hyperformula#VALUE! libreoffice6 formulas6 pycel#NAME?
date/98f2b9 =WEEKNUM("2025-01-05") 2 gsheets2 excel2 lattice2 ironcalc2 hyperformula#VALUE! libreoffice2 formulas2 pycel#NAME?
date/881477 =WEEKNUM("2025-01-05", 2) 1 gsheets1 excel1 lattice1 ironcalc1 hyperformula#VALUE! libreoffice1 formulas1 pycel#NAME?
date/81d5c5 =WORKDAY("2025-03-03", 5) 45726 gsheets45726 excel45726 lattice45726 ironcalc45726 hyperformula#VALUE! libreoffice45726 formulas45726 pycel#NAME?
date/2c2fe9 =WORKDAY("2025-03-10", -5) 45719 gsheets45719 excel45719 lattice45719 ironcalc45719 hyperformula#VALUE! libreoffice45719 formulas45719 pycel#NAME?
date/79d179 =WORKDAY("2025-03-03", 0) 45719 gsheets45719 excel45719 lattice45719 ironcalc45719 hyperformula#VALUE! libreoffice45719 formulas45719 pycel#NAME?
date/60ae88 =WORKDAY.INTL("2025-03-03", 5, 1) 45726 gsheets45726 excel45726 lattice45726 ironcalc45726 hyperformula#VALUE! libreoffice45726 formulas45726 pycel#NAME?
date/046128 =WORKDAY.INTL("2025-03-03", 5, 7) 45726 gsheets45726 excel45726 lattice45726 ironcalc45726 hyperformula#VALUE! libreoffice45726 formulas45726 pycel#NAME?
date/13319d =WORKDAY.INTL("2025-03-03", 5, "0000011") 45726 gsheets45726 excel45726 lattice45726 ironcalc45726 hyperformula#VALUE! libreoffice45726 formulas45726 pycel#NAME?
date/2fa3fa =WORKDAY.INTL("2025-03-03", 5, "0000001") 45724 gsheets45724 excel45724 lattice45724 ironcalc45724 hyperformula#VALUE! libreoffice45724 formulas45724 pycel#NAME?
text-longtail/9006fb =SPLIT("a,b,c", ",") [a, b, c] gsheets[a, b, c] excel#N/A lattice[a, b, c] ironcalc#NAME? hyperformula#VALUE! libreoffice#NAME? formulas#NAME? pycel#NAME?
text-longtail/4d1bcd =SPLIT("a-b_c", "-_") [a, b, c] gsheets[a, b, c] excel#N/A lattice[a, b, c] ironcalc#NAME? hyperformula#VALUE! libreoffice#NAME? formulas#NAME? pycel#NAME?
text-longtail/0a0a13 =SPLIT("hello", ",") hello gsheetshello excel#N/A latticehello ironcalc#NAME? hyperformula#VALUE! libreoffice#NAME? formulas#NAME? pycel#NAME?