diff options
| author | xuri <xuri.me@gmail.com> | 2021-03-19 23:23:05 +0800 |
|---|---|---|
| committer | xuri <xuri.me@gmail.com> | 2021-03-19 23:23:05 +0800 |
| commit | d3227393efb037bc13a4b5f7b150715f22761b4d (patch) | |
| tree | c10cbbdc13f2f5f3c4a6bc5334212df64f94ed73 /calc_test.go | |
| parent | 9af00b9b98daa2beca7bbf7805b88da4963a8cd1 (diff) | |
#65 fn: DATEDIF
Diffstat (limited to 'calc_test.go')
| -rw-r--r-- | calc_test.go | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/calc_test.go b/calc_test.go index 6b7093e..6fc61b0 100644 --- a/calc_test.go +++ b/calc_test.go @@ -722,6 +722,20 @@ func TestCalcCellValue(t *testing.T) { // DATE "=DATE(2020,10,21)": "2020-10-21 00:00:00 +0000 UTC", "=DATE(1900,1,1)": "1899-12-31 00:00:00 +0000 UTC", + // DATEDIF + "=DATEDIF(43101,43101,\"D\")": "0", + "=DATEDIF(43101,43891,\"d\")": "790", + "=DATEDIF(43101,43891,\"Y\")": "2", + "=DATEDIF(42156,44242,\"y\")": "5", + "=DATEDIF(43101,43891,\"M\")": "26", + "=DATEDIF(42171,44242,\"m\")": "67", + "=DATEDIF(42156,44454,\"MD\")": "14", + "=DATEDIF(42171,44242,\"md\")": "30", + "=DATEDIF(43101,43891,\"YM\")": "2", + "=DATEDIF(42171,44242,\"ym\")": "7", + "=DATEDIF(43101,43891,\"YD\")": "59", + "=DATEDIF(36526,73110,\"YD\")": "60", + "=DATEDIF(42171,44242,\"yd\")": "244", // Text Functions // CHAR "=CHAR(65)": "A", @@ -1436,6 +1450,11 @@ func TestCalcCellValue(t *testing.T) { `=DATE("text",10,21)`: "DATE requires 3 number arguments", `=DATE(2020,"text",21)`: "DATE requires 3 number arguments", `=DATE(2020,10,"text")`: "DATE requires 3 number arguments", + // DATEDIF + "=DATEDIF()": "DATEDIF requires 3 number arguments", + "=DATEDIF(\"\",\"\",\"\")": "strconv.ParseFloat: parsing \"\": invalid syntax", + "=DATEDIF(43891,43101,\"Y\")": "start_date > end_date", + "=DATEDIF(43101,43891,\"x\")": "DATEDIF has invalid unit", // NOW "=NOW(A1)": "NOW accepts no arguments", // TODAY |