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
date/129a60 =DAY("2025-03-15") 15 gsheets15 excel15 lattice15 ironcalc15 hyperformula#VALUE! libreoffice15 formulas15 pycel#VALUE!
date/c8e0eb =DAY("2025-01-31") 31 gsheets31 excel31 lattice31 ironcalc31 hyperformula#VALUE! libreoffice31 formulas31 pycel#VALUE!
date/d70217 =DAY("2024-02-29") 29 gsheets29 excel29 lattice29 ironcalc29 hyperformula#VALUE! libreoffice29 formulas29 pycel#VALUE!
date/93c302 =EDATE("2025-01-15", 3) 45762 gsheets45762 excel45762 lattice45762 ironcalc45762 hyperformula#VALUE! libreoffice45762 formulas45762 pycel#VALUE!
date/84511d =EDATE("2025-01-15", -3) 45580 gsheets45580 excel45580 lattice45580 ironcalc45580 hyperformula#VALUE! libreoffice45580 formulas45580 pycel#VALUE!
date/18d93a =EDATE("2025-01-31", 1) 45716 gsheets45716 excel45716 lattice45716 ironcalc45716 hyperformula#VALUE! libreoffice45716 formulas45716 pycel#VALUE!
date/e55076 =EDATE("2025-03-15", 0) 45731 gsheets45731 excel45731 lattice45731 ironcalc45731 hyperformula#VALUE! libreoffice45731 formulas45731 pycel#VALUE!
date/508d67 =EOMONTH("2025-03-15", 0) 45747 gsheets45747 excel45747 lattice45747 ironcalc45747 hyperformula#VALUE! libreoffice45747 formulas45747 pycel#VALUE!
date/dd8343 =EOMONTH("2025-03-15", 2) 45808 gsheets45808 excel45808 lattice45808 ironcalc45808 hyperformula#VALUE! libreoffice45808 formulas45808 pycel#VALUE!
date/04cfe3 =EOMONTH("2025-03-15", -1) 45716 gsheets45716 excel45716 lattice45716 ironcalc45716 hyperformula#VALUE! libreoffice45716 formulas45716 pycel#VALUE!
date/32629b =EOMONTH("2024-02-10", 0) 45351 gsheets45351 excel45351 lattice45351 ironcalc45351 hyperformula#VALUE! libreoffice45351 formulas45351 pycel#VALUE!
date/12fa4c =MONTH("2025-03-15") 3 gsheets3 excel3 lattice3 ironcalc3 hyperformula#VALUE! libreoffice3 formulas3 pycel#VALUE!
date/577ba3 =MONTH("2025-12-31") 12 gsheets12 excel12 lattice12 ironcalc12 hyperformula#VALUE! libreoffice12 formulas12 pycel#VALUE!
date/74abbd =WEEKDAY("2025-03-16") 1 gsheets1 excel1 lattice1 ironcalc1 hyperformula#VALUE! libreoffice1 formulas1 pycel#VALUE!
date/3857f9 =WEEKDAY("2025-03-17", 1) 2 gsheets2 excel2 lattice2 ironcalc2 hyperformula#VALUE! libreoffice2 formulas2 pycel#VALUE!
date/db3d66 =WEEKDAY("2025-03-17", 2) 1 gsheets1 excel1 lattice1 ironcalc1 hyperformula#VALUE! libreoffice1 formulas1 pycel#VALUE!
date/bf55ff =WEEKDAY("2025-03-17", 3) 0 gsheets0 excel0 lattice0 ironcalc0 hyperformula#VALUE! libreoffice0 formulas0 pycel#VALUE!
date/7c28b7 =YEAR("2025-03-15") 2025 gsheets2025 excel2025 lattice2025 ironcalc2025 hyperformula#VALUE! libreoffice2025 formulas2025 pycel#VALUE!
date/f17d55 =YEAR("2000-01-01") 2000 gsheets2000 excel2000 lattice2000 ironcalc2000 hyperformula#VALUE! libreoffice2000 formulas2000 pycel#VALUE!
date/83857b =YEARFRAC("2025-01-01", "2025-07-01") 0.5 gsheets0.5 excel0.5 lattice0.5 ironcalc0.5 hyperformula#VALUE! libreoffice0.5 formulas0.5 pycel#VALUE!
date/7c7488 =YEARFRAC("2025-01-01", "2026-01-01", 0) 1 gsheets1 excel1 lattice1 ironcalc1 hyperformula#VALUE! libreoffice1 formulas1 pycel#VALUE!
date/1045d9 =YEARFRAC("2025-01-01", "2026-01-01", 1) 1 gsheets1 excel1 lattice1 ironcalc1 hyperformula#VALUE! libreoffice1 formulas1 pycel#VALUE!
date/69069f =YEARFRAC("2025-03-15", "2025-03-15") 0 gsheets0 excel0 lattice0 ironcalc0 hyperformula#VALUE! libreoffice0 formulas0 pycel#VALUE!