Weeknumber test suite
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
Still loading...
ABCDEFG
1
Test suite for the WeekNumber function. Conforms to ISO8601 week number specification. Read more at http://www.freakcode.com/projects/google-spreadsheet-week-numbers
2
#NAME?
3
DateExpected WeekActual WeekOutcomeExpected ISO string formActual ISO stringOutcome
4
2005-01-015353Success2004-W532004-W53Success
5
2005-01-025353Success2004-W532004-W53Success
6
2005-12-315252Success2005-W522005-W52Success
7
2007-01-0111Success2007-W012007-W01Success
8
2007-12-305252Success2007-W522007-W52Success
9
2007-12-3111Success2008-W012008-W01Success
10
2008-01-0111Success2008-W012008-W01Success
11
2008-12-2911Success2009-W012009-W01Success
12
2008-12-3111Success2009-W012009-W01Success
13
2009-01-0111Success2009-W012009-W01Success
14
2009-12-315353Success2009-W532009-W53Success
15
2010-01-035353Success2009-W532009-W53Success
16
2009-12-315353Success2009-W532009-W53Success
17
2010-01-015353Success2009-W532009-W53Success
18
2010-01-025353Success2009-W532009-W53Success
19
2010-01-035353Success2009-W532009-W53Success
20
2010-01-0411Success2010-W012010-W01Success
21
2008-12-285252Success2008-W522008-W52Success
22
2008-12-2911Success2009-W012009-W01Success
23
2008-12-3011Success2009-W012009-W01Success
24
2008-12-3111Success2009-W012009-W01Success
25
2009-01-0111Success2009-W012009-W01Success
26
2011-01-0311Success2011-W012011-W01Success
27
2010-09-203838Success2010-W382010-W38Success
28
2012-01-015252Success2011-W522011-W52Success
29
Some test data retrieved from http://en.wikipedia.org/wiki/ISO_week_date#Examples
Loading...
 
 
 
Sheet1