assay

DV-0014

hyperformula, pycel: different error code — DAY, EDATE, EOMONTH (+4 more)

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

Subjects (7)

DAY EDATE EOMONTH MONTH WEEKDAY YEAR YEARFRAC

Tests (23)

matches canonical diverges no fixture in this DV's cluster

Test Formula Canonical gsheets excel lattice ironcalc hyperformula libreoffice formulas pycel
DAY/day-from-string =DAY("2025-03-15") 15 gsheets15 excel15 lattice15 ironcalc15 hyperformula#VALUE! libreoffice— formulas15 pycel#VALUE!
DAY/day-end-of-month =DAY("2025-01-31") 31 gsheets31 excel31 lattice31 ironcalc31 hyperformula#VALUE! libreoffice— formulas31 pycel#VALUE!
DAY/day-leap-day =DAY("2024-02-29") 29 gsheets29 excel29 lattice29 ironcalc29 hyperformula#VALUE! libreoffice— formulas29 pycel#VALUE!
EDATE/edate-forward =EDATE("2025-01-15", 3) 45762 gsheets45762 excel45762 lattice45762 ironcalc45762 hyperformula#VALUE! libreoffice— formulas45762 pycel#VALUE!
EDATE/edate-backward =EDATE("2025-01-15", -3) 45580 gsheets45580 excel45580 lattice45580 ironcalc45580 hyperformula#VALUE! libreoffice— formulas45580 pycel#NAME?
EDATE/edate-month-end-clamp =EDATE("2025-01-31", 1) 45716 gsheets45716 excel45716 lattice45716 ironcalc45716 hyperformula#VALUE! libreoffice— formulas45716 pycel#VALUE!
EDATE/edate-zero =EDATE("2025-03-15", 0) 45731 gsheets45731 excel45731 lattice45731 ironcalc45731 hyperformula#VALUE! libreoffice— formulas45731 pycel#VALUE!
EOMONTH/eomonth-current-month =EOMONTH("2025-03-15", 0) 45747 gsheets45747 excel45747 lattice45747 ironcalc45747 hyperformula#VALUE! libreoffice— formulas45747 pycel#VALUE!
EOMONTH/eomonth-forward-by-2 =EOMONTH("2025-03-15", 2) 45808 gsheets45808 excel45808 lattice45808 ironcalc45808 hyperformula#VALUE! libreoffice— formulas45808 pycel#VALUE!
EOMONTH/eomonth-backward =EOMONTH("2025-03-15", -1) 45716 gsheets45716 excel45716 lattice45716 ironcalc45716 hyperformula#VALUE! libreoffice— formulas45716 pycel#NAME?
EOMONTH/eomonth-leap-february =EOMONTH("2024-02-10", 0) 45351 gsheets45351 excel45351 lattice45351 ironcalc45351 hyperformula#VALUE! libreoffice— formulas45351 pycel#VALUE!
MONTH/month-from-string =MONTH("2025-03-15") 3 gsheets3 excel3 lattice3 ironcalc3 hyperformula#VALUE! libreoffice— formulas3 pycel#VALUE!
MONTH/month-december =MONTH("2025-12-31") 12 gsheets12 excel12 lattice12 ironcalc12 hyperformula#VALUE! libreoffice— formulas12 pycel#VALUE!
WEEKDAY/weekday-default-sunday-1 =WEEKDAY("2025-03-16") 1 gsheets1 excel1 lattice1 ironcalc1 hyperformula#VALUE! libreoffice— formulas1 pycel#VALUE!
WEEKDAY/weekday-sunday-1-convention =WEEKDAY("2025-03-17", 1) 2 gsheets2 excel2 lattice2 ironcalc2 hyperformula#VALUE! libreoffice— formulas2 pycel#VALUE!
WEEKDAY/weekday-monday-1-convention =WEEKDAY("2025-03-17", 2) 1 gsheets1 excel1 lattice1 ironcalc1 hyperformula#VALUE! libreoffice— formulas1 pycel#VALUE!
WEEKDAY/weekday-monday-0-convention =WEEKDAY("2025-03-17", 3) 0 gsheets0 excel0 lattice0 ironcalc0 hyperformula#VALUE! libreoffice— formulas0 pycel#VALUE!
YEAR/year-from-string =YEAR("2025-03-15") 2025 gsheets2025 excel2025 lattice2025 ironcalc2025 hyperformula#VALUE! libreoffice— formulas2025 pycel#VALUE!
YEAR/year-millennium =YEAR("2000-01-01") 2000 gsheets2000 excel2000 lattice2000 ironcalc2000 hyperformula#VALUE! libreoffice— formulas2000 pycel#VALUE!
YEARFRAC/yearfrac-half-year-default =YEARFRAC("2025-01-01", "2025-07-01") 0.5 gsheets0.5 excel0.5 lattice0.5 ironcalc0.5 hyperformula#VALUE! libreoffice— formulas0.5 pycel#VALUE!
YEARFRAC/yearfrac-us-30-360 =YEARFRAC("2025-01-01", "2026-01-01", 0) 1 gsheets1 excel1 lattice1 ironcalc1 hyperformula#VALUE! libreoffice— formulas1 pycel#VALUE!
YEARFRAC/yearfrac-actual-actual =YEARFRAC("2025-01-01", "2026-01-01", 1) 1 gsheets1 excel1 lattice1 ironcalc1 hyperformula#VALUE! libreoffice— formulas1 pycel#VALUE!
YEARFRAC/yearfrac-same-date =YEARFRAC("2025-03-15", "2025-03-15") 0 gsheets0 excel0 lattice0 ironcalc0 hyperformula#VALUE! libreoffice— formulas0 pycel#VALUE!