assay

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 gsheets[object Object] excel[object Object] lattice5 ironcalc5 hyperformula#VALUE! libreoffice— formulas5 pycel#NAME?
DATEDIF/datedif-months =DATEDIF("2020-01-15", "2025-03-20", "M") 62 gsheets[object Object] excel[object Object] lattice62 ironcalc62 hyperformula#VALUE! libreoffice— formulas62 pycel#NAME?
DATEDIF/datedif-days =DATEDIF("2025-01-01", "2025-02-01", "D") 31 gsheets[object Object] excel[object Object] lattice31 ironcalc31 hyperformula#VALUE! libreoffice— formulas31 pycel#NAME?
DATEDIF/datedif-md-day-only =DATEDIF("2020-01-15", "2025-03-20", "MD") 5 gsheets[object Object] excel[object Object] lattice5 ironcalc5 hyperformula#VALUE! libreoffice— formulas5 pycel#NAME?
DATEDIF/datedif-ym-month-only =DATEDIF("2020-01-15", "2025-03-20", "YM") 2 gsheets[object Object] excel[object Object] lattice2 ironcalc2 hyperformula#VALUE! libreoffice— formulas2 pycel#NAME?
DATEVALUE/datevalue-iso =DATEVALUE("2025-03-15") 45731 gsheets[object Object] excel[object Object] lattice45731 ironcalc45731 hyperformula#VALUE! libreoffice— formulas45731 pycel45731
DAYS/days-basic =DAYS("2025-03-15", "2025-03-01") 14 gsheets[object Object] excel[object Object] lattice14 ironcalc14 hyperformula#VALUE! libreoffice— formulas14 pycel#NAME?
DAYS/days-negative =DAYS("2025-03-01", "2025-03-15") -14 gsheets[object Object] excel[object Object] lattice-14 ironcalc-14 hyperformula#VALUE! libreoffice— formulas-14 pycel#NAME?
DAYS/days-same-day =DAYS("2025-03-15", "2025-03-15") 0 gsheets[object Object] excel[object Object] lattice0 ironcalc0 hyperformula#VALUE! libreoffice— formulas0 pycel#NAME?
DAYS/days-across-year =DAYS("2025-01-01", "2024-01-01") 366 gsheets[object Object] excel[object Object] lattice366 ironcalc366 hyperformula#VALUE! libreoffice— formulas366 pycel#NAME?
DAYS360/days360-basic =DAYS360("2025-01-15", "2025-03-15") 60 gsheets[object Object] excel[object Object] lattice60 ironcalc60 hyperformula#VALUE! libreoffice— formulas60 pycel#NAME?
DAYS360/days360-full-year =DAYS360("2024-01-01", "2025-01-01") 360 gsheets[object Object] excel[object Object] lattice360 ironcalc360 hyperformula#VALUE! libreoffice— formulas360 pycel#NAME?
DAYS360/days360-european-method =DAYS360("2025-01-31", "2025-03-31", TRUE) 60 gsheets[object Object] excel[object Object] lattice60 ironcalc60 hyperformula#VALUE! libreoffice— formulas60 pycel#NAME?
ISOWEEKNUM/isoweeknum-mid-year =ISOWEEKNUM("2025-06-15") 24 gsheets[object Object] excel[object Object] lattice24 ironcalc24 hyperformula#VALUE! libreoffice— formulas24 pycel#NAME?
ISOWEEKNUM/isoweeknum-jan-1-belongs-to-prev-year =ISOWEEKNUM("2023-01-01") 52 gsheets[object Object] excel[object Object] lattice52 ironcalc52 hyperformula#VALUE! libreoffice— formulas52 pycel#NAME?
ISOWEEKNUM/isoweeknum-first-week =ISOWEEKNUM("2024-01-01") 1 gsheets[object Object] excel[object Object] lattice1 ironcalc1 hyperformula#VALUE! libreoffice— formulas1 pycel#NAME?
NETWORKDAYS/networkdays-basic-week =NETWORKDAYS("2025-03-03", "2025-03-07") 5 gsheets[object Object] excel[object Object] lattice5 ironcalc5 hyperformula#VALUE! libreoffice— formulas5 pycel#NAME?
NETWORKDAYS/networkdays-across-weekend =NETWORKDAYS("2025-03-07", "2025-03-10") 2 gsheets[object Object] excel[object Object] lattice2 ironcalc2 hyperformula#VALUE! libreoffice— formulas2 pycel#NAME?
NETWORKDAYS/networkdays-reversed =NETWORKDAYS("2025-03-07", "2025-03-03") -5 gsheets[object Object] excel[object Object] 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 gsheets[object Object] excel[object Object] 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 gsheets[object Object] excel[object Object] 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 gsheets[object Object] excel[object Object] 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 gsheets[object Object] excel[object Object] lattice6 ironcalc6 hyperformula#VALUE! libreoffice— formulas6 pycel#NAME?
WEEKNUM/weeknum-default =WEEKNUM("2025-01-05") 2 gsheets[object Object] excel[object Object] lattice2 ironcalc2 hyperformula#VALUE! libreoffice— formulas2 pycel#NAME?
WEEKNUM/weeknum-monday-start =WEEKNUM("2025-01-05", 2) 1 gsheets[object Object] excel[object Object] lattice1 ironcalc1 hyperformula#VALUE! libreoffice— formulas1 pycel#NAME?
WORKDAY/workday-forward =WORKDAY("2025-03-03", 5) 45726 gsheets[object Object] excel[object Object] lattice45726 ironcalc45726 hyperformula#VALUE! libreoffice— formulas45726 pycel#NAME?
WORKDAY/workday-backward =WORKDAY("2025-03-10", -5) 45719 gsheets[object Object] excel[object Object] lattice45719 ironcalc45719 hyperformula#VALUE! libreoffice— formulas45719 pycel#NAME?
WORKDAY/workday-zero-offset =WORKDAY("2025-03-03", 0) 45719 gsheets[object Object] excel[object Object] lattice45719 ironcalc45719 hyperformula#VALUE! libreoffice— formulas45719 pycel#NAME?
WORKDAY.INTL/workday-intl-default-weekend =WORKDAY.INTL("2025-03-03", 5, 1) 45726 gsheets[object Object] excel[object Object] lattice45726 ironcalc45726 hyperformula#VALUE! libreoffice— formulas45726 pycel#NAME?
WORKDAY.INTL/workday-intl-numeric-weekend-fri-sat =WORKDAY.INTL("2025-03-03", 5, 7) 45726 gsheets[object Object] excel[object Object] lattice45726 ironcalc45726 hyperformula#VALUE! libreoffice— formulas45726 pycel#NAME?
WORKDAY.INTL/workday-intl-string-weekend =WORKDAY.INTL("2025-03-03", 5, "0000011") 45726 gsheets[object Object] excel[object Object] lattice45726 ironcalc45726 hyperformula#VALUE! libreoffice— formulas45726 pycel#NAME?
WORKDAY.INTL/workday-intl-sunday-only-string =WORKDAY.INTL("2025-03-03", 5, "0000001") 45724 gsheets[object Object] excel[object Object] lattice45724 ironcalc45724 hyperformula#VALUE! libreoffice— formulas45724 pycel#NAME?
SPLIT/split-comma =SPLIT("a,b,c", ",") {a, b, c} gsheets{[object Object], [object Object], [object Object]} 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{[object Object], [object Object], [object Object]} excel— lattice{a, b, c} ironcalc#NAME? hyperformula#VALUE! libreoffice— formulas#NAME? pycel#NAME?
SPLIT/split-single-token =SPLIT("hello", ",") hello gsheets[object Object] excel— latticehello ironcalc#NAME? hyperformula#VALUE! libreoffice— formulas#NAME? pycel#NAME?