diff options
| author | xuri <xuri.me@gmail.com> | 2022-06-10 00:10:22 +0800 |
|---|---|---|
| committer | xuri <xuri.me@gmail.com> | 2022-06-10 00:10:22 +0800 |
| commit | 980fffa2b621e933ab16debf9d9106b005941589 (patch) | |
| tree | dd29ca41b6f9de2d01c844812317d95e6631e038 /calc_test.go | |
| parent | 604a01bf6b3b1e0d95fe3501f6309d3ed78b900c (diff) | |
ref #65: new formula function EDATE
Diffstat (limited to 'calc_test.go')
| -rw-r--r-- | calc_test.go | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/calc_test.go b/calc_test.go index 874a3e5..ab282ca 100644 --- a/calc_test.go +++ b/calc_test.go @@ -1475,6 +1475,10 @@ func TestCalcCellValue(t *testing.T) { "=DAYS(2,1)": "1", "=DAYS(INT(2),INT(1))": "1", "=DAYS(\"02/02/2015\",\"01/01/2015\")": "32", + // EDATE + "=EDATE(\"01/01/2021\",-1)": "44166", + "=EDATE(\"01/31/2020\",1)": "43890", + "=EDATE(\"01/29/2020\",12)": "44225", // HOUR "=HOUR(1)": "0", "=HOUR(43543.5032060185)": "12", @@ -3437,6 +3441,12 @@ func TestCalcCellValue(t *testing.T) { "=DAYS(0,\"\")": "#VALUE!", "=DAYS(NA(),0)": "#VALUE!", "=DAYS(0,NA())": "#VALUE!", + // EDATE + "=EDATE()": "EDATE requires 2 arguments", + "=EDATE(0,\"\")": "strconv.ParseFloat: parsing \"\": invalid syntax", + "=EDATE(-1,0)": "#NUM!", + "=EDATE(\"\",0)": "#VALUE!", + "=EDATE(\"January 25, 100\",0)": "#VALUE!", // HOUR "=HOUR()": "HOUR requires exactly 1 argument", "=HOUR(-1)": "HOUR only accepts positive argument", |