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 gsheets[object Object] excel[object Object] lattice15 ironcalc15 hyperformula#VALUE! libreoffice— formulas15 pycel#VALUE!
DAY/day-end-of-month =DAY("2025-01-31") 31 gsheets[object Object] excel[object Object] lattice31 ironcalc31 hyperformula#VALUE! libreoffice— formulas31 pycel#VALUE!
DAY/day-leap-day =DAY("2024-02-29") 29 gsheets[object Object] excel[object Object] lattice29 ironcalc29 hyperformula#VALUE! libreoffice— formulas29 pycel#VALUE!
EDATE/edate-forward =EDATE("2025-01-15", 3) 45762 gsheets[object Object] excel[object Object] lattice45762 ironcalc45762 hyperformula#VALUE! libreoffice— formulas45762 pycel#VALUE!
EDATE/edate-backward =EDATE("2025-01-15", -3) 45580 gsheets[object Object] excel[object Object] lattice45580 ironcalc45580 hyperformula#VALUE! libreoffice— formulas45580 pycel#NAME?
EDATE/edate-month-end-clamp =EDATE("2025-01-31", 1) 45716 gsheets[object Object] excel[object Object] lattice45716 ironcalc45716 hyperformula#VALUE! libreoffice— formulas45716 pycel#VALUE!
EDATE/edate-zero =EDATE("2025-03-15", 0) 45731 gsheets[object Object] excel[object Object] lattice45731 ironcalc45731 hyperformula#VALUE! libreoffice— formulas45731 pycel#VALUE!
EOMONTH/eomonth-current-month =EOMONTH("2025-03-15", 0) 45747 gsheets[object Object] excel[object Object] lattice45747 ironcalc45747 hyperformula#VALUE! libreoffice— formulas45747 pycel#VALUE!
EOMONTH/eomonth-forward-by-2 =EOMONTH("2025-03-15", 2) 45808 gsheets[object Object] excel[object Object] lattice45808 ironcalc45808 hyperformula#VALUE! libreoffice— formulas45808 pycel#VALUE!
EOMONTH/eomonth-backward =EOMONTH("2025-03-15", -1) 45716 gsheets[object Object] excel[object Object] lattice45716 ironcalc45716 hyperformula#VALUE! libreoffice— formulas45716 pycel#NAME?
EOMONTH/eomonth-leap-february =EOMONTH("2024-02-10", 0) 45351 gsheets[object Object] excel[object Object] lattice45351 ironcalc45351 hyperformula#VALUE! libreoffice— formulas45351 pycel#VALUE!
MONTH/month-from-string =MONTH("2025-03-15") 3 gsheets[object Object] excel[object Object] lattice3 ironcalc3 hyperformula#VALUE! libreoffice— formulas3 pycel#VALUE!
MONTH/month-december =MONTH("2025-12-31") 12 gsheets[object Object] excel[object Object] lattice12 ironcalc12 hyperformula#VALUE! libreoffice— formulas12 pycel#VALUE!
WEEKDAY/weekday-default-sunday-1 =WEEKDAY("2025-03-16") 1 gsheets[object Object] excel[object Object] lattice1 ironcalc1 hyperformula#VALUE! libreoffice— formulas1 pycel#VALUE!
WEEKDAY/weekday-sunday-1-convention =WEEKDAY("2025-03-17", 1) 2 gsheets[object Object] excel[object Object] lattice2 ironcalc2 hyperformula#VALUE! libreoffice— formulas2 pycel#VALUE!
WEEKDAY/weekday-monday-1-convention =WEEKDAY("2025-03-17", 2) 1 gsheets[object Object] excel[object Object] lattice1 ironcalc1 hyperformula#VALUE! libreoffice— formulas1 pycel#VALUE!
WEEKDAY/weekday-monday-0-convention =WEEKDAY("2025-03-17", 3) 0 gsheets[object Object] excel[object Object] lattice0 ironcalc0 hyperformula#VALUE! libreoffice— formulas0 pycel#VALUE!
YEAR/year-from-string =YEAR("2025-03-15") 2025 gsheets[object Object] excel[object Object] lattice2025 ironcalc2025 hyperformula#VALUE! libreoffice— formulas2025 pycel#VALUE!
YEAR/year-millennium =YEAR("2000-01-01") 2000 gsheets[object Object] excel[object Object] lattice2000 ironcalc2000 hyperformula#VALUE! libreoffice— formulas2000 pycel#VALUE!
YEARFRAC/yearfrac-half-year-default =YEARFRAC("2025-01-01", "2025-07-01") 0.5 gsheets[object Object] excel[object Object] 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 gsheets[object Object] excel[object Object] lattice1 ironcalc1 hyperformula#VALUE! libreoffice— formulas1 pycel#VALUE!
YEARFRAC/yearfrac-actual-actual =YEARFRAC("2025-01-01", "2026-01-01", 1) 1 gsheets[object Object] excel[object Object] lattice1 ironcalc1 hyperformula#VALUE! libreoffice— formulas1 pycel#VALUE!
YEARFRAC/yearfrac-same-date =YEARFRAC("2025-03-15", "2025-03-15") 0 gsheets[object Object] excel[object Object] lattice0 ironcalc0 hyperformula#VALUE! libreoffice— formulas0 pycel#VALUE!