diff options
| author | xuri <xuri.me@gmail.com> | 2022-06-11 14:08:21 +0800 |
|---|---|---|
| committer | xuri <xuri.me@gmail.com> | 2022-06-11 14:08:21 +0800 |
| commit | f5d3d59d8c65d9396893ae0156fef21592f6f425 (patch) | |
| tree | 533b032628f3d169b11931ec6523a5918a8f5dc7 /calc_test.go | |
| parent | 980fffa2b621e933ab16debf9d9106b005941589 (diff) | |
ref #65: new formula function EOMONTH
Diffstat (limited to 'calc_test.go')
| -rw-r--r-- | calc_test.go | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/calc_test.go b/calc_test.go index ab282ca..6c2c649 100644 --- a/calc_test.go +++ b/calc_test.go @@ -1479,6 +1479,11 @@ func TestCalcCellValue(t *testing.T) { "=EDATE(\"01/01/2021\",-1)": "44166", "=EDATE(\"01/31/2020\",1)": "43890", "=EDATE(\"01/29/2020\",12)": "44225", + "=EDATE(\"6/12/2021\",-14)": "43933", + // EOMONTH + "=EOMONTH(\"01/01/2021\",-1)": "44196", + "=EOMONTH(\"01/29/2020\",12)": "44227", + "=EOMONTH(\"01/12/2021\",-18)": "43677", // HOUR "=HOUR(1)": "0", "=HOUR(43543.5032060185)": "12", @@ -3447,6 +3452,12 @@ func TestCalcCellValue(t *testing.T) { "=EDATE(-1,0)": "#NUM!", "=EDATE(\"\",0)": "#VALUE!", "=EDATE(\"January 25, 100\",0)": "#VALUE!", + // EOMONTH + "=EOMONTH()": "EOMONTH requires 2 arguments", + "=EOMONTH(0,\"\")": "strconv.ParseFloat: parsing \"\": invalid syntax", + "=EOMONTH(-1,0)": "#NUM!", + "=EOMONTH(\"\",0)": "#VALUE!", + "=EOMONTH(\"January 25, 100\",0)": "#VALUE!", // HOUR "=HOUR()": "HOUR requires exactly 1 argument", "=HOUR(-1)": "HOUR only accepts positive argument", |