Get week number in year from date

  
Week_when_DateFirst1

1
6


  
Week_when_DateFirst7

1
5


  
date
datefirst1
datefirst2
datefirst3
datefirst4
datefirst5
datefirst6
datefirst7

1
2017-01-01
1
1
1
1
1
1
1

2
2017-01-02
2
1
1
1
1
1
1

3
2017-01-03
2
2
1
1
1
1
1

4
2017-01-04
2
2
2
1
1
1
1

5
2017-01-05
2
2
2
2
1
1
1

6
2017-01-06
2
2
2
2
2
1
1

7
2017-01-07
2
2
2
2
2
2
1

8
2017-01-08
2
2
2
2
2
2
2

9
2017-01-09
3
2
2
2
2
2
2

10
2017-01-10
3
3
2
2
2
2
2

11
2017-01-11
3
3
3
2
2
2
2

12
2017-01-12
3
3
3
3
2
2
2

13
2017-01-13
3
3
3
3
3
2
2

14
2017-01-14
3
3
3
3
3
3
2

15
2017-01-15
3
3
3
3
3
3
3

16
2017-01-16
4
3
3
3
3
3
3

17
2017-01-17
4
4
3
3
3
3
3

18
2017-01-18
4
4
4
3
3
3
3

19
2017-01-19
4
4
4
4
3
3
3

20
2017-01-20
4
4
4
4
4
3
3

21
2017-01-21
4
4
4
4
4
4
3

22
2017-01-22
4
4
4
4
4
4
4

23
2017-01-23
5
4
4
4
4
4
4

24
2017-01-24
5
5
4
4
4
4
4

25
2017-01-25
5
5
5
4
4
4
4

26
2017-01-26
5
5
5
5
4
4
4

27
2017-01-27
5
5
5
5
5
4
4

28
2017-01-28
5
5
5
5
5
5
4

29
2017-01-29
5
5
5
5
5
5
5

30
2017-01-30
6
5
5
5
5
5
5

31
2017-01-31
6
6
5
5
5
5
5

32
2017-02-01
6
6
6
5
5
5
5

33
2017-02-02
6
6
6
6
5
5
5

34
2017-02-03
6
6
6
6
6
5
5

35
2017-02-04
6
6
6
6
6
6
5

36
2017-02-05
6
6
6
6
6
6
6

37
2017-02-06
7
6
6
6
6
6
6

38
2017-02-07
7
7
6
6
6
6
6

39
2017-02-08
7
7
7
6
6
6
6

40
2017-02-09
7
7
7
7
6
6
6

41
2017-02-10
7
7
7
7
7
6
6

42
2017-02-11
7
7
7
7
7
7
6

43
2017-02-12
7
7
7
7
7
7
7

44
2017-02-13
8
7
7
7
7
7
7

45
2017-02-14
8
8
7
7
7
7
7

46
2017-02-15
8
8
8
7
7
7
7

47
2017-02-16
8
8
8
8
7
7
7

48
2017-02-17
8
8
8
8
8
7
7

49
2017-02-18
8
8
8
8
8
8
7

50
2017-02-19
8
8
8
8
8
8
8

51
2017-02-20
9
8
8
8
8
8
8

52
2017-02-21
9
9
8
8
8
8
8

53
2017-02-22
9
9
9
8
8
8
8

54
2017-02-23
9
9
9
9
8
8
8

55
2017-02-24
9
9
9
9
9
8
8

56
2017-02-25
9
9
9
9
9
9
8

57
2017-02-26
9
9
9
9
9
9
9

58
2017-02-27
10
9
9
9
9
9
9

59
2017-02-28
10
10
9
9
9
9
9