diff options
| author | Stani <spe.stani.be@gmail.com> | 2021-08-21 14:15:53 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2021-08-21 20:15:53 +0800 |
| commit | 9b55f4f9f0b839934eb8113d2092c60a1a5b64b8 (patch) | |
| tree | 5e63e75b107f6180636cd846b0fce8461b90a4c5 /calc_test.go | |
| parent | 4d716fa7edde76ed838aefcd8c5945bcfe3ba8f3 (diff) | |
This closes #1006, new fn: MONTH ref #65
Co-authored-by: xuri <xuri.me@gmail.com>
Diffstat (limited to 'calc_test.go')
| -rw-r--r-- | calc_test.go | 15 |
1 files changed, 14 insertions, 1 deletions
diff --git a/calc_test.go b/calc_test.go index cea9521..e5a6e1e 100644 --- a/calc_test.go +++ b/calc_test.go @@ -965,6 +965,13 @@ func TestCalcCellValue(t *testing.T) { // MONTH "=MONTH(42171)": "6", "=MONTH(\"31-May-2015\")": "5", + // YEAR + "=YEAR(15)": "1900", + "=YEAR(\"15\")": "1900", + "=YEAR(2048)": "1905", + "=YEAR(42171)": "2015", + "=YEAR(\"29-May-2015\")": "2015", + "=YEAR(\"05/03/1984\")": "1984", // Text Functions // CHAR "=CHAR(65)": "A", @@ -1986,10 +1993,16 @@ func TestCalcCellValue(t *testing.T) { "=DAY(\"0-January-1900\")": "#VALUE!", // MONTH "=MONTH()": "MONTH requires exactly 1 argument", - "=MONTH(43891,43101)": "MONTH requires exactly 1 argument", + "=MONTH(0,0)": "MONTH requires exactly 1 argument", "=MONTH(-1)": "MONTH only accepts positive argument", "=MONTH(\"text\")": "#VALUE!", "=MONTH(\"January 25, 100\")": "#VALUE!", + // YEAR + "=YEAR()": "YEAR requires exactly 1 argument", + "=YEAR(0,0)": "YEAR requires exactly 1 argument", + "=YEAR(-1)": "YEAR only accepts positive argument", + "=YEAR(\"text\")": "#VALUE!", + "=YEAR(\"January 25, 100\")": "#VALUE!", // NOW "=NOW(A1)": "NOW accepts no arguments", // TODAY |