Convert daily sums to weekly sums

Moh Bit

Join Date: Oct 2018
Posts: 20

Convert daily sums to weekly sums

19 Mar 2022, 10:14

Dear all,

I have a sample of 130 countries. The sample consists of the daily number of new COVID-19 cases. I would like to convert the variable to report the weekly number (sum) of COVID-19 cases and the quarterly number (sum) of COVID-19 cases.

Any advice on this is much appreciated. I am providing an example of the data set I am currently working with. For simplicity, I am only including 2 countries. Thank you.

Code:

* Example generated by -dataex-. For more info, type help dataex
clear
input str3 iso_code str10 date long new_cases
"AFG" "2020-02-24"     5
"AFG" "2020-02-25"     0
"AFG" "2020-02-26"     0
"AFG" "2020-02-27"     0
"AFG" "2020-02-28"     0
"AFG" "2020-02-29"     0
"AFG" "2020-03-01"     0
"AFG" "2020-03-02"     0
"AFG" "2020-03-03"     0
"AFG" "2020-03-04"     0
"AFG" "2020-03-05"     0
"AFG" "2020-03-06"     0
"AFG" "2020-03-07"     3
"AFG" "2020-03-08"     0
"AFG" "2020-03-09"     0
"AFG" "2020-03-10"     0
"AFG" "2020-03-11"     3
"AFG" "2020-03-12"     0
"AFG" "2020-03-13"     0
"AFG" "2020-03-14"     3
"AFG" "2020-03-15"     6
"AFG" "2020-03-16"     5
"AFG" "2020-03-17"     1
"AFG" "2020-03-18"     0
"AFG" "2020-03-19"     0
"AFG" "2020-03-20"     .
"AFG" "2020-03-21"     0
"AFG" "2020-03-22"    10
"AFG" "2020-03-23"     6
"AFG" "2020-03-24"     2
"AFG" "2020-03-25"    32
"AFG" "2020-03-26"     6
"AFG" "2020-03-27"    11
"AFG" "2020-03-28"    15
"AFG" "2020-03-29"     8
"AFG" "2020-03-30"     0
"AFG" "2020-03-31"    52
"AFG" "2020-04-01"    26
"AFG" "2020-04-02"    43
"AFG" "2020-04-03"    34
"AFG" "2020-04-04"     1
"AFG" "2020-04-05"    29
"AFG" "2020-04-06"    38
"AFG" "2020-04-07"    30
"AFG" "2020-04-08"    56
"AFG" "2020-04-09"    21
"AFG" "2020-04-10"    77
"AFG" "2020-04-11"     0
"AFG" "2020-04-12"    34
"AFG" "2020-04-13"    52
"AFG" "2020-04-14"    58
"AFG" "2020-04-15"   105
"AFG" "2020-04-16"    24
"AFG" "2020-04-17"    51
"AFG" "2020-04-18"    63
"AFG" "2020-04-19"    25
"AFG" "2020-04-20"    63
"AFG" "2020-04-21"    30
"AFG" "2020-04-22"    66
"AFG" "2020-04-23"    84
"AFG" "2020-04-24"    50
"AFG" "2020-04-25"   104
"AFG" "2020-04-26"   133
"AFG" "2020-04-27"    68
"AFG" "2020-04-28"   172
"AFG" "2020-04-29"   124
"AFG" "2020-04-30"     0
"AFG" "2020-05-01"   344
"AFG" "2020-05-02"   298
"AFG" "2020-05-03"     0
"AFG" "2020-05-04"     0
"AFG" "2020-05-05"     0
"AFG" "2020-05-06"   755
"AFG" "2020-05-07"   168
"AFG" "2020-05-08"   171
"AFG" "2020-05-09"     0
"AFG" "2020-05-10"   839
"AFG" "2020-05-11"   262
"AFG" "2020-05-12"   303
"AFG" "2020-05-13"     0
"AFG" "2020-05-14"   372
"AFG" "2020-05-15"   714
"AFG" "2020-05-16"   349
"AFG" "2020-05-17"   233
"AFG" "2020-05-18"   437
"AFG" "2020-05-19"   583
"AFG" "2020-05-20"   490
"AFG" "2020-05-21"   531
"AFG" "2020-05-22"   540
"AFG" "2020-05-23"   736
"AFG" "2020-05-24"   716
"AFG" "2020-05-25"   512
"AFG" "2020-05-26"   737
"AFG" "2020-05-27"   548
"AFG" "2020-05-28"   637
"AFG" "2020-05-29"   643
"AFG" "2020-05-30"   784
"AFG" "2020-05-31"   651
"AFG" "2020-06-01"   656
"AFG" "2020-06-02"   742
"AFG" "2020-06-03"   775
"AFG" "2020-06-04"   624
"AFG" "2020-06-05"  1078
"AFG" "2020-06-06"   582
"AFG" "2020-06-07"   791
"AFG" "2020-06-08"   575
"AFG" "2020-06-09"   305
"AFG" "2020-06-10"   920
"AFG" "2020-06-11"   748
"AFG" "2020-06-12"   656
"AFG" "2020-06-13"   556
"AFG" "2020-06-14"   664
"AFG" "2020-06-15"   761
"AFG" "2020-06-16"   106
"AFG" "2020-06-17"  1241
"AFG" "2020-06-18"   463
"AFG" "2020-06-19"   541
"AFG" "2020-06-20"   419
"AFG" "2020-06-21"   536
"AFG" "2020-06-22"   310
"AFG" "2020-06-23"   338
"AFG" "2020-06-24"   159
"AFG" "2020-06-25"   535
"AFG" "2020-06-26"    85
"AFG" "2020-06-27"   356
"AFG" "2020-06-28"   351
"AFG" "2020-06-29"   271
"AFG" "2020-06-30"   121
"AFG" "2020-07-01"   403
"AFG" "2020-07-02"   260
"AFG" "2020-07-03"   302
"AFG" "2020-07-04"   348
"AFG" "2020-07-05"   279
"AFG" "2020-07-06"   113
"AFG" "2020-07-07"   320
"AFG" "2020-07-08"   210
"AFG" "2020-07-09"    59
"AFG" "2020-07-10"   541
"AFG" "2020-07-11"   157
"AFG" "2020-07-12"   100
"AFG" "2020-07-13"     4
"AFG" "2020-07-14"   285
"AFG" "2020-07-15"   200
"AFG" "2020-07-16"   130
"AFG" "2020-07-17"   159
"AFG" "2020-07-18"    60
"AFG" "2020-07-19"   186
"AFG" "2020-07-20"    34
"AFG" "2020-07-21"   106
"AFG" "2020-07-22"   112
"AFG" "2020-07-23"   188
"AFG" "2020-07-24"    66
"AFG" "2020-07-25"    55
"AFG" "2020-07-26"   121
"AFG" "2020-07-27"   106
"AFG" "2020-07-28"   105
"AFG" "2020-07-29"   103
"AFG" "2020-07-30"    71
"AFG" "2020-07-31"     0
"AFG" "2020-08-01"   168
"AFG" "2020-08-02"     0
"AFG" "2020-08-03"     0
"AFG" "2020-08-04"    37
"AFG" "2020-08-05"    82
"AFG" "2020-08-06"    67
"AFG" "2020-08-07"    41
"AFG" "2020-08-08"    78
"AFG" "2020-08-09"    39
"AFG" "2020-08-10"     0
"AFG" "2020-08-11"   215
"AFG" "2020-08-12"    76
"AFG" "2020-08-13"    79
"AFG" "2020-08-14"     7
"AFG" "2020-08-15"   120
"AFG" "2020-08-16"    45
"AFG" "2020-08-17"     0
"AFG" "2020-08-18"     3
"AFG" "2020-08-19"     0
"AFG" "2020-08-20"   160
"AFG" "2020-08-21"    97
"AFG" "2020-08-22"    38
"AFG" "2020-08-23"    59
"AFG" "2020-08-24"    46
"AFG" "2020-08-25"    71
"AFG" "2020-08-26"    43
"AFG" "2020-08-27"    16
"AFG" "2020-08-28"    11
"AFG" "2020-08-29"     3
"AFG" "2020-08-30"     0
"AFG" "2020-08-31"    19
"AFG" "2020-09-01"    34
"AFG" "2020-09-02"    47
"AFG" "2020-09-03"    45
"AFG" "2020-09-04"     0
"AFG" "2020-09-05"    16
"AFG" "2020-09-06"    94
"AFG" "2020-09-07"    96
"AFG" "2020-09-08"    26
"AFG" "2020-09-09"    24
"AFG" "2020-09-10"    28
"AFG" "2020-09-11"    34
"AFG" "2020-09-12"    35
"AFG" "2020-09-13"    75
"AFG" "2020-09-14"    56
"AFG" "2020-09-15"    43
"AFG" "2020-09-16"    40
"AFG" "2020-09-17"    17
"AFG" "2020-09-18"    11
"AFG" "2020-09-19"    36
"AFG" "2020-09-20"   125
"AFG" "2020-09-21"    30
"AFG" "2020-09-22"    22
"AFG" "2020-09-23"    49
"AFG" "2020-09-24"    25
"AFG" "2020-09-25"    16
"AFG" "2020-09-26"     6
"AFG" "2020-09-27"    35
"AFG" "2020-09-28"    12
"AFG" "2020-09-29"    15
"AFG" "2020-09-30"    14
"AFG" "2020-10-01"    17
"AFG" "2020-10-02"     5
"AFG" "2020-10-03"     7
"AFG" "2020-10-04"    44
"AFG" "2020-10-05"    81
"AFG" "2020-10-06"    64
"AFG" "2020-10-07"    62
"AFG" "2020-10-08"    68
"AFG" "2020-10-09"    77
"AFG" "2020-10-10"    10
"AFG" "2020-10-11"    96
"AFG" "2020-10-12"    71
"AFG" "2020-10-13"    58
"AFG" "2020-10-14"    66
"AFG" "2020-10-15"    32
"AFG" "2020-10-16"    47
"AFG" "2020-10-17"    68
"AFG" "2020-10-18"    59
"AFG" "2020-10-19"    87
"AFG" "2020-10-20"    88
"AFG" "2020-10-21"     0
"AFG" "2020-10-22"    49
"AFG" "2020-10-23"   116
"AFG" "2020-10-24"    61
"AFG" "2020-10-25"    81
"AFG" "2020-10-26"    65
"AFG" "2020-10-27"   104
"AFG" "2020-10-28"    95
"AFG" "2020-10-29"   113
"AFG" "2020-10-30"   123
"AFG" "2020-10-31"    66
"AFG" "2020-11-01"    91
"AFG" "2020-11-02"    76
"AFG" "2020-11-03"   132
"AFG" "2020-11-04"    95
"AFG" "2020-11-05"    86
"AFG" "2020-11-06"   121
"AFG" "2020-11-07"    40
"AFG" "2020-11-08"    58
"AFG" "2020-11-09"   126
"AFG" "2020-11-10"   138
"AFG" "2020-11-11"   166
"AFG" "2020-11-12"   146
"AFG" "2020-11-13"   186
"AFG" "2020-11-14"   174
"AFG" "2020-11-15"    66
"AFG" "2020-11-16"   205
"AFG" "2020-11-17"   163
"AFG" "2020-11-18"   225
"AFG" "2020-11-19"   223
"AFG" "2020-11-20"   377
"AFG" "2020-11-21"   215
"AFG" "2020-11-22"    60
"AFG" "2020-11-23"   203
"AFG" "2020-11-24"   282
"AFG" "2020-11-25"   290
"AFG" "2020-11-26"   212
"AFG" "2020-11-27"   226
"AFG" "2020-11-28"   123
"AFG" "2020-11-29"   127
"AFG" "2020-11-30"   249
"AFG" "2020-12-01"   283
"AFG" "2020-12-02"   219
"AFG" "2020-12-03"   263
"AFG" "2020-12-04"   278
"AFG" "2020-12-05"   130
"AFG" "2020-12-06"   253
"AFG" "2020-12-07"   260
"AFG" "2020-12-08"   235
"AFG" "2020-12-09"   230
"AFG" "2020-12-10"   174
"AFG" "2020-12-11"   213
"AFG" "2020-12-12"    73
"AFG" "2020-12-13"   126
"AFG" "2020-12-14"   321
"AFG" "2020-12-15"   211
"AFG" "2020-12-16"   219
"AFG" "2020-12-17"   224
"AFG" "2020-12-18"   275
"AFG" "2020-12-19"   254
"AFG" "2020-12-20"    80
"AFG" "2020-12-21"   142
"AFG" "2020-12-22"   210
"AFG" "2020-12-23"   182
"AFG" "2020-12-24"   287
"AFG" "2020-12-25"   238
"AFG" "2020-12-26"   169
"AFG" "2020-12-27"    84
"AFG" "2020-12-28"   159
"AFG" "2020-12-29"   140
"AFG" "2020-12-30"   183
"AFG" "2020-12-31"     0
"AFG" "2021-01-01"   183
"AFG" "2021-01-02"    73
"AFG" "2021-01-03"   123
"AFG" "2021-01-04"   200
"AFG" "2021-01-05"   102
"AFG" "2021-01-06"    94
"AFG" "2021-01-07"   102
"AFG" "2021-01-08"   125
"AFG" "2021-01-09"    68
"AFG" "2021-01-10"    89
"AFG" "2021-01-11"    49
"AFG" "2021-01-12"    46
"AFG" "2021-01-13"   106
"AFG" "2021-01-14"    85
"AFG" "2021-01-15"    56
"AFG" "2021-01-16"   107
"AFG" "2021-01-17"    46
"AFG" "2021-01-18"    78
"AFG" "2021-01-19"    79
"AFG" "2021-01-20"   137
"AFG" "2021-01-21"   125
"AFG" "2021-01-22"    80
"AFG" "2021-01-23"    76
"AFG" "2021-01-24"    36
"AFG" "2021-01-25"    77
"AFG" "2021-01-26"    78
"AFG" "2021-01-27"   104
"AFG" "2021-01-28"    37
"AFG" "2021-01-29"    48
"AFG" "2021-01-30"    69
"AFG" "2021-01-31"    15
"AFG" "2021-02-01"    36
"AFG" "2021-02-02"    62
"AFG" "2021-02-03"    53
"AFG" "2021-02-04"    57
"AFG" "2021-02-05"    34
"AFG" "2021-02-06"    65
"AFG" "2021-02-07"     5
"AFG" "2021-02-08"    24
"AFG" "2021-02-09"    25
"AFG" "2021-02-10"    18
"AFG" "2021-02-11"    18
"AFG" "2021-02-12"    25
"AFG" "2021-02-13"    28
"AFG" "2021-02-14"    19
"AFG" "2021-02-15"    22
"AFG" "2021-02-16"     4
"AFG" "2021-02-17"    22
"AFG" "2021-02-18"    17
"AFG" "2021-02-19"    18
"AFG" "2021-02-20"     5
"AFG" "2021-02-21"    24
"AFG" "2021-02-22"    13
"AFG" "2021-02-23"    29
"AFG" "2021-02-24"    18
"AFG" "2021-02-25"    16
"AFG" "2021-02-26"    16
"AFG" "2021-02-27"    11
"AFG" "2021-02-28"     7
"AFG" "2021-03-01"    19
"AFG" "2021-03-02"    26
"AFG" "2021-03-03"    11
"AFG" "2021-03-04"     5
"AFG" "2021-03-05"    52
"AFG" "2021-03-06"    13
"AFG" "2021-03-07"     7
"AFG" "2021-03-08"    29
"AFG" "2021-03-09"     0
"AFG" "2021-03-10"    18
"AFG" "2021-03-11"    23
"AFG" "2021-03-12"    42
"AFG" "2021-03-13"     0
"AFG" "2021-03-14"    26
"AFG" "2021-03-15"     0
"AFG" "2021-03-16"    10
"AFG" "2021-03-17"    21
"AFG" "2021-03-18"    28
"AFG" "2021-03-19"    25
"AFG" "2021-03-20"    24
"AFG" "2021-03-21"    10
"AFG" "2021-03-22"    50
"AFG" "2021-03-23"    24
"AFG" "2021-03-24"    15
"AFG" "2021-03-25"    34
"AFG" "2021-03-26"    28
"AFG" "2021-03-27"    36
"AFG" "2021-03-28"     4
"AFG" "2021-03-29"    28
"AFG" "2021-03-30"    62
"AFG" "2021-03-31"    70
"AFG" "2021-04-01"    63
"AFG" "2021-04-02"    55
"AFG" "2021-04-03"    23
"AFG" "2021-04-04"    81
"AFG" "2021-04-05"    41
"AFG" "2021-04-06"    62
"AFG" "2021-04-07"    94
"AFG" "2021-04-08"    70
"AFG" "2021-04-09"    76
"AFG" "2021-04-10"   125
"AFG" "2021-04-11"    16
"AFG" "2021-04-12"    82
"AFG" "2021-04-13"   122
"AFG" "2021-04-14"   128
"AFG" "2021-04-15"    42
"AFG" "2021-04-16"    78
"AFG" "2021-04-17"   109
"AFG" "2021-04-18"    72
"AFG" "2021-04-19"   105
"AFG" "2021-04-20"   139
"AFG" "2021-04-21"   177
"AFG" "2021-04-22"    98
"AFG" "2021-04-23"   230
"AFG" "2021-04-24"   188
"AFG" "2021-04-25"   113
"AFG" "2021-04-26"   172
"AFG" "2021-04-27"   210
"AFG" "2021-04-28"   145
"AFG" "2021-04-29"   206
"AFG" "2021-04-30"   169
"AFG" "2021-05-01"   194
"AFG" "2021-05-02"   183
"AFG" "2021-05-03"   178
"AFG" "2021-05-04"   263
"AFG" "2021-05-05"   234
"AFG" "2021-05-06"   365
"AFG" "2021-05-07"   293
"AFG" "2021-05-08"   300
"AFG" "2021-05-09"    87
"AFG" "2021-05-10"   221
"AFG" "2021-05-11"   340
"AFG" "2021-05-12"   315
"AFG" "2021-05-13"   327
"AFG" "2021-05-14"   310
"AFG" "2021-05-15"    57
"AFG" "2021-05-16"    72
"AFG" "2021-05-17"   114
"AFG" "2021-05-18"   221
"AFG" "2021-05-19"   303
"AFG" "2021-05-20"   453
"AFG" "2021-05-21"   505
"AFG" "2021-05-22"   406
"AFG" "2021-05-23"   242
"AFG" "2021-05-24"   547
"AFG" "2021-05-25"   628
"AFG" "2021-05-26"   840
"AFG" "2021-05-27"   623
"AFG" "2021-05-28"   764
"AFG" "2021-05-29"   981
"AFG" "2021-05-30"   650
"AFG" "2021-05-31"  1077
"AFG" "2021-06-01"  1139
"AFG" "2021-06-02"  1049
"AFG" "2021-06-03"  1093
"AFG" "2021-06-04"  1509
"AFG" "2021-06-05"  1335
"AFG" "2021-06-06"  1261
"AFG" "2021-06-07"  1617
"AFG" "2021-06-08"  1485
"AFG" "2021-06-09"  1724
"AFG" "2021-06-10"  1842
"AFG" "2021-06-11"  1824
"AFG" "2021-06-12"  1024
"AFG" "2021-06-13"  1121
"AFG" "2021-06-14"  1597
"AFG" "2021-06-15"  1814
"AFG" "2021-06-16"    16
"AFG" "2021-06-17"  3243
"AFG" "2021-06-18"  2203
"AFG" "2021-06-19"  1787
"AFG" "2021-06-20"  1385
"AFG" "2021-06-21"  1996
"AFG" "2021-06-22"  1847
"AFG" "2021-06-23"  2208
"AFG" "2021-06-24"  1575
"AFG" "2021-06-25"  2060
"AFG" "2021-06-26"  1532
"AFG" "2021-06-27"  1096
"AFG" "2021-06-28"  1531
"AFG" "2021-06-29"  1407
"AFG" "2021-06-30"  1501
"AFG" "2021-07-01"  1557
"AFG" "2021-07-02"  1940
"AFG" "2021-07-03"  1329
"AFG" "2021-07-04"  1263
"AFG" "2021-07-05"  1189
"AFG" "2021-07-06"  1527
"AFG" "2021-07-07"  1557
"AFG" "2021-07-08"  1092
"AFG" "2021-07-09"  1473
"AFG" "2021-07-10"  1191
"AFG" "2021-07-11"   801
"AFG" "2021-07-12"  1075
"AFG" "2021-07-13"  1236
"AFG" "2021-07-14"   754
"AFG" "2021-07-15"  1210
"AFG" "2021-07-16"  1198
"AFG" "2021-07-17"  1173
"AFG" "2021-07-18"   378
"AFG" "2021-07-19"   897
"AFG" "2021-07-20"   915
"AFG" "2021-07-21"   348
"AFG" "2021-07-22"   421
"AFG" "2021-07-23"   256
"AFG" "2021-07-24"   227
"AFG" "2021-07-25"   205
"AFG" "2021-07-26"   414
"AFG" "2021-07-27"   723
"AFG" "2021-07-28"   544
"AFG" "2021-07-29"   444
"AFG" "2021-07-30"   527
"AFG" "2021-07-31"   631
"AFG" "2021-08-01"   347
"AFG" "2021-08-02"   484
"AFG" "2021-08-03"   587
"AFG" "2021-08-04"   361
"AFG" "2021-08-05"   428
"AFG" "2021-08-06"   449
"AFG" "2021-08-07"   430
"AFG" "2021-08-08"   218
"AFG" "2021-08-09"   320
"AFG" "2021-08-10"   235
"AFG" "2021-08-11"   278
"AFG" "2021-08-12"   272
"AFG" "2021-08-13"   207
"AFG" "2021-08-14"   171
"AFG" "2021-08-15"    92
"AFG" "2021-08-16"   109
"AFG" "2021-08-17"   101
"AFG" "2021-08-18"   120
"AFG" "2021-08-19"    48
"AFG" "2021-08-20"    37
"AFG" "2021-08-21"    49
"AFG" "2021-08-22"    14
"AFG" "2021-08-23"    72
"AFG" "2021-08-24"    77
"AFG" "2021-08-25"    62
"AFG" "2021-08-26"   100
"AFG" "2021-08-27"   138
"AFG" "2021-08-28"    47
"AFG" "2021-08-29"    26
"AFG" "2021-08-30"   115
"AFG" "2021-08-31"    72
"AFG" "2021-09-01"    40
"AFG" "2021-09-02"    46
"AFG" "2021-09-03"    69
"AFG" "2021-09-04"    20
"AFG" "2021-09-05"    28
"AFG" "2021-09-06"   111
"AFG" "2021-09-07"    92
"AFG" "2021-09-08"   110
"AFG" "2021-09-09"   104
"AFG" "2021-09-10"   122
"AFG" "2021-09-11"    20
"AFG" "2021-09-12"     8
"AFG" "2021-09-13"   104
"AFG" "2021-09-14"    86
"AFG" "2021-09-15"   103
"AFG" "2021-09-16"    78
"AFG" "2021-09-17"   126
"AFG" "2021-09-18"     0
"AFG" "2021-09-19"     0
"AFG" "2021-09-20"    98
"AFG" "2021-09-21"   127
"AFG" "2021-09-22"    45
"AFG" "2021-09-23"    43
"AFG" "2021-09-24"   160
"AFG" "2021-09-25"     0
"AFG" "2021-09-26"     0
"AFG" "2021-09-27"   112
"AFG" "2021-09-28"    21
"AFG" "2021-09-29"    35
"AFG" "2021-09-30"    46
"AFG" "2021-10-01"    17
"AFG" "2021-10-02"     0
"AFG" "2021-10-03"     0
"AFG" "2021-10-04"    96
"AFG" "2021-10-05"    22
"AFG" "2021-10-06"    71
"AFG" "2021-10-07"    49
"AFG" "2021-10-08"    19
"AFG" "2021-10-09"    18
"AFG" "2021-10-10"    42
"AFG" "2021-10-11"    32
"AFG" "2021-10-12"    59
"AFG" "2021-10-13"    28
"AFG" "2021-10-14"    55
"AFG" "2021-10-15"     6
"AFG" "2021-10-16"    51
"AFG" "2021-10-17"    25
"AFG" "2021-10-18"    12
"AFG" "2021-10-19"    25
"AFG" "2021-10-20"    58
"AFG" "2021-10-21"    32
"AFG" "2021-10-22"    40
"AFG" "2021-10-23"     9
"AFG" "2021-10-24"     4
"AFG" "2021-10-25"    96
"AFG" "2021-10-26"    31
"AFG" "2021-10-27"    53
"AFG" "2021-10-28"    42
"AFG" "2021-10-29"    30
"AFG" "2021-10-30"    14
"AFG" "2021-10-31"    40
"AFG" "2021-11-01"    34
"AFG" "2021-11-02"    23
"AFG" "2021-11-03"    16
"AFG" "2021-11-04"    40
"AFG" "2021-11-05"    29
"AFG" "2021-11-06"     5
"AFG" "2021-11-07"     0
"AFG" "2021-11-08"     0
"AFG" "2021-11-09"     0
"AFG" "2021-11-10"    17
"AFG" "2021-11-11"    42
"AFG" "2021-11-12"    31
"AFG" "2021-11-13"    23
"AFG" "2021-11-14"    42
"AFG" "2021-11-15"    58
"AFG" "2021-11-16"    39
"AFG" "2021-11-17"    90
"AFG" "2021-11-18"     0
"AFG" "2021-11-19"    73
"AFG" "2021-11-20"    52
"AFG" "2021-11-21"    32
"AFG" "2021-11-22"    15
"AFG" "2021-11-23"   104
"AFG" "2021-11-24"    17
"AFG" "2021-11-25"   112
"AFG" "2021-11-26"    27
"AFG" "2021-11-27"    19
"AFG" "2021-11-28"    28
"AFG" "2021-11-29"    42
"AFG" "2021-11-30"    29
"AFG" "2021-12-01"    70
"AFG" "2021-12-02"    28
"AFG" "2021-12-03"    25
"AFG" "2021-12-04"    19
"AFG" "2021-12-05"    23
"AFG" "2021-12-06"    45
"AFG" "2021-12-07"     9
"AFG" "2021-12-08"    34
"AFG" "2021-12-09"    43
"AFG" "2021-12-10"    18
"AFG" "2021-12-11"     8
"AFG" "2021-12-12"    22
"AFG" "2021-12-13"    15
"AFG" "2021-12-14"    12
"AFG" "2021-12-15"     5
"AFG" "2021-12-16"    60
"AFG" "2021-12-17"     9
"AFG" "2021-12-18"    11
"AFG" "2021-12-19"    42
"AFG" "2021-12-20"    10
"AFG" "2021-12-21"    19
"AFG" "2021-12-22"    25
"AFG" "2021-12-23"    37
"AFG" "2021-12-24"     9
"AFG" "2021-12-25"     8
"AFG" "2021-12-26"    56
"AFG" "2021-12-27"    16
"AFG" "2021-12-28"    31
"AFG" "2021-12-29"    39
"AFG" "2021-12-30"    19
"AFG" "2021-12-31"    28
"ALB" "2020-02-25"     .
"ALB" "2020-02-26"     .
"ALB" "2020-02-27"     .
"ALB" "2020-02-28"     .
"ALB" "2020-02-29"     .
"ALB" "2020-03-01"     .
"ALB" "2020-03-02"     .
"ALB" "2020-03-03"     .
"ALB" "2020-03-04"     .
"ALB" "2020-03-05"     .
"ALB" "2020-03-06"     .
"ALB" "2020-03-07"     .
"ALB" "2020-03-08"     .
"ALB" "2020-03-09"     2
"ALB" "2020-03-10"     8
"ALB" "2020-03-11"     2
"ALB" "2020-03-12"    11
"ALB" "2020-03-13"    10
"ALB" "2020-03-14"     5
"ALB" "2020-03-15"     4
"ALB" "2020-03-16"     9
"ALB" "2020-03-17"     4
"ALB" "2020-03-18"     4
"ALB" "2020-03-19"     5
"ALB" "2020-03-20"     6
"ALB" "2020-03-21"     6
"ALB" "2020-03-22"    13
"ALB" "2020-03-23"    15
"ALB" "2020-03-24"    19
"ALB" "2020-03-25"    23
"ALB" "2020-03-26"    28
"ALB" "2020-03-27"    12
"ALB" "2020-03-28"    11
"ALB" "2020-03-29"    15
"ALB" "2020-03-30"    11
"ALB" "2020-03-31"    20
"ALB" "2020-04-01"    16
"ALB" "2020-04-02"    18
"ALB" "2020-04-03"    27
"ALB" "2020-04-04"    29
"ALB" "2020-04-05"    28
"ALB" "2020-04-06"    16
"ALB" "2020-04-07"     6
"ALB" "2020-04-08"    17
"ALB" "2020-04-09"     9
"ALB" "2020-04-10"     7
"ALB" "2020-04-11"    17
"ALB" "2020-04-12"    13
"ALB" "2020-04-13"    21
"ALB" "2020-04-14"     8
"ALB" "2020-04-15"    19
"ALB" "2020-04-16"    24
"ALB" "2020-04-17"    21
"ALB" "2020-04-18"     9
"ALB" "2020-04-19"    14
"ALB" "2020-04-20"    22
"ALB" "2020-04-21"    25
"ALB" "2020-04-22"    25
"ALB" "2020-04-23"    29
"ALB" "2020-04-24"    15
"ALB" "2020-04-25"    34
"ALB" "2020-04-26"    14
"ALB" "2020-04-27"    10
"ALB" "2020-04-28"    14
"ALB" "2020-04-29"    16
"ALB" "2020-04-30"     7
"ALB" "2020-05-01"     9
"ALB" "2020-05-02"     7
"ALB" "2020-05-03"     6
"ALB" "2020-05-04"     8
"ALB" "2020-05-05"    17
"ALB" "2020-05-06"    12
"ALB" "2020-05-07"    10
"ALB" "2020-05-08"     8
"ALB" "2020-05-09"     6
"ALB" "2020-05-10"    12
"ALB" "2020-05-11"     4
"ALB" "2020-05-12"     4
"ALB" "2020-05-13"     4
"ALB" "2020-05-14"    18
"ALB" "2020-05-15"    18
"ALB" "2020-05-16"    17
"ALB" "2020-05-17"    13
"ALB" "2020-05-18"     2
"ALB" "2020-05-19"     1
"ALB" "2020-05-20"    15
"ALB" "2020-05-21"     5
"ALB" "2020-05-22"    12
"ALB" "2020-05-23"     8
"ALB" "2020-05-24"     9
"ALB" "2020-05-25"     6
"ALB" "2020-05-26"    25
"ALB" "2020-05-27"    21
"ALB" "2020-05-28"    26
"ALB" "2020-05-29"    23
"ALB" "2020-05-30"    23
"ALB" "2020-05-31"    15
"ALB" "2020-06-01"     6
"ALB" "2020-06-02"    21
"ALB" "2020-06-03"    20
"ALB" "2020-06-04"    13
"ALB" "2020-06-05"    15
"ALB" "2020-06-06"    20
"ALB" "2020-06-07"    14
"ALB" "2020-06-08"    17
"ALB" "2020-06-09"    36
"ALB" "2020-06-10"    42
"ALB" "2020-06-11"    44
"ALB" "2020-06-12"    31
"ALB" "2020-06-13"    48
"ALB" "2020-06-14"    57
"ALB" "2020-06-15"    69
"ALB" "2020-06-16"    82
"ALB" "2020-06-17"    50
"ALB" "2020-06-18"    66
"ALB" "2020-06-19"    50
"ALB" "2020-06-20"    53
"ALB" "2020-06-21"    71
"ALB" "2020-06-22"    33
"ALB" "2020-06-23"    52
"ALB" "2020-06-24"    67
"ALB" "2020-06-25"    78
"ALB" "2020-06-26"    77
"ALB" "2020-06-27"    61
"ALB" "2020-06-28"    72
"ALB" "2020-06-29"    64
"ALB" "2020-06-30"    69
"ALB" "2020-07-01"    45
"ALB" "2020-07-02"    82
"ALB" "2020-07-03"    90
"ALB" "2020-07-04"    67
"ALB" "2020-07-05"    74
"ALB" "2020-07-06"    71
"ALB" "2020-07-07"    74
"ALB" "2020-07-08"    68
"ALB" "2020-07-09"    82
"ALB" "2020-07-10"    90
"ALB" "2020-07-11"    93
"ALB" "2020-07-12"    83
"ALB" "2020-07-13"   117
"ALB" "2020-07-14"    96
"ALB" "2020-07-15"    85
"ALB" "2020-07-16"    99
"ALB" "2020-07-17"    55
"ALB" "2020-07-18"   102
"ALB" "2020-07-19"    82
"ALB" "2020-07-20"    81
"ALB" "2020-07-21"   119
"ALB" "2020-07-22"    68
"ALB" "2020-07-23"   108
"ALB" "2020-07-24"   104
"ALB" "2020-07-25"    67
"ALB" "2020-07-26"   126
"ALB" "2020-07-27"   117
"ALB" "2020-07-28"   117
"ALB" "2020-07-29"   108
"ALB" "2020-07-30"    92
"ALB" "2020-07-31"    79
"ALB" "2020-08-01"   120
"ALB" "2020-08-02"   123
"ALB" "2020-08-03"   101
"ALB" "2020-08-04"   130
"ALB" "2020-08-05"   139
"ALB" "2020-08-06"   127
"ALB" "2020-08-07"   135
"ALB" "2020-08-08"   124
"ALB" "2020-08-09"   136
"ALB" "2020-08-10"   125
"ALB" "2020-08-11"   140
"ALB" "2020-08-12"   141
"ALB" "2020-08-13"   154
"ALB" "2020-08-14"   146
"ALB" "2020-08-15"   143
"ALB" "2020-08-16"   120
"ALB" "2020-08-17"   119
"ALB" "2020-08-18"   155
"ALB" "2020-08-19"   158
"ALB" "2020-08-20"   155
"ALB" "2020-08-21"   152
"ALB" "2020-08-22"   156
"ALB" "2020-08-23"   152
"ALB" "2020-08-24"   178
"ALB" "2020-08-25"   154
"ALB" "2020-08-26"   168
"ALB" "2020-08-27"   156
"ALB" "2020-08-28"   112
"ALB" "2020-08-29"    84
"ALB" "2020-08-30"   101
"ALB" "2020-08-31"   133
"ALB" "2020-09-01"    93
"ALB" "2020-09-02"   122
"ALB" "2020-09-03"   116
"ALB" "2020-09-04"   123
"ALB" "2020-09-05"   135
"ALB" "2020-09-06"   153
"ALB" "2020-09-07"   151
"ALB" "2020-09-08"   147
"ALB" "2020-09-09"   151
"ALB" "2020-09-10"   156
"ALB" "2020-09-11"   161
"ALB" "2020-09-12"   164
"ALB" "2020-09-13"   168
"ALB" "2020-09-14"   167
"ALB" "2020-09-15"   152
"ALB" "2020-09-16"   144
"ALB" "2020-09-17"   132
"ALB" "2020-09-18"   125
"ALB" "2020-09-19"   153
"ALB" "2020-09-20"   159
"ALB" "2020-09-21"   150
"ALB" "2020-09-22"   131
"ALB" "2020-09-23"   121
"ALB" "2020-09-24"   134
"ALB" "2020-09-25"   124
"ALB" "2020-09-26"   108
"ALB" "2020-09-27"   106
"ALB" "2020-09-28"   132
"ALB" "2020-09-29"   127
"ALB" "2020-09-30"   131
"ALB" "2020-10-01"   157
"ALB" "2020-10-02"   159
"ALB" "2020-10-03"   152
"ALB" "2020-10-04"   149
"ALB" "2020-10-05"   144
"ALB" "2020-10-06"   158
"ALB" "2020-10-07"   162
"ALB" "2020-10-08"   169
"ALB" "2020-10-09"   167
"ALB" "2020-10-10"   165
"ALB" "2020-10-11"   168
"ALB" "2020-10-12"   171
"ALB" "2020-10-13"   182
"ALB" "2020-10-14"   203
"ALB" "2020-10-15"   257
"ALB" "2020-10-16"   289
"ALB" "2020-10-17"   273
"ALB" "2020-10-18"   281
"ALB" "2020-10-19"   295
"ALB" "2020-10-20"   301
"ALB" "2020-10-21"   297
"ALB" "2020-10-22"   302
"ALB" "2020-10-23"   306
"ALB" "2020-10-24"   302
"ALB" "2020-10-25"   299
"ALB" "2020-10-26"   288
"ALB" "2020-10-27"   284
"ALB" "2020-10-28"   311
"ALB" "2020-10-29"   275
"ALB" "2020-10-30"   319
"ALB" "2020-10-31"   241
"ALB" "2020-11-01"   327
"ALB" "2020-11-02"   321
"ALB" "2020-11-03"   381
"ALB" "2020-11-04"   396
"ALB" "2020-11-05"   421
"ALB" "2020-11-06"   489
"ALB" "2020-11-07"   495
"ALB" "2020-11-08"   501
"ALB" "2020-11-09"   525
"ALB" "2020-11-10"   563
"ALB" "2020-11-11"   507
"ALB" "2020-11-12"   410
"ALB" "2020-11-13"   490
"ALB" "2020-11-14"   532
"ALB" "2020-11-15"   597
"ALB" "2020-11-16"   602
"ALB" "2020-11-17"   694
"ALB" "2020-11-18"   711
"ALB" "2020-11-19"   786
"ALB" "2020-11-20"   836
"ALB" "2020-11-21"   737
"ALB" "2020-11-22"   565
"ALB" "2020-11-23"   795
"ALB" "2020-11-24"   744
"ALB" "2020-11-25"   644
"ALB" "2020-11-26"   656
"ALB" "2020-11-27"   645
"ALB" "2020-11-28"   545
"ALB" "2020-11-29"   835
"ALB" "2020-11-30"   557
"ALB" "2020-12-01"   832
"ALB" "2020-12-02"   705
"ALB" "2020-12-03"   782
"ALB" "2020-12-04"   801
"ALB" "2020-12-05"   846
"ALB" "2020-12-06"   840
"ALB" "2020-12-07"   695
"ALB" "2020-12-08"   753
"ALB" "2020-12-09"   752
"ALB" "2020-12-10"   873
"ALB" "2020-12-11"   802
"ALB" "2020-12-12"   879
"ALB" "2020-12-13"   788
"ALB" "2020-12-14"   661
"ALB" "2020-12-15"   809
"ALB" "2020-12-16"   637
"ALB" "2020-12-17"   787
"ALB" "2020-12-18"   580
"ALB" "2020-12-19"   538
"ALB" "2020-12-20"   461
"ALB" "2020-12-21"   422
"ALB" "2020-12-22"   389
"ALB" "2020-12-23"   503
"ALB" "2020-12-24"   510
"ALB" "2020-12-25"   553
"ALB" "2020-12-26"   375
"ALB" "2020-12-27"   499
"ALB" "2020-12-28"   318
"ALB" "2020-12-29"   574
"ALB" "2020-12-30"   581
"ALB" "2020-12-31"   589
"ALB" "2021-01-01"     0
"ALB" "2021-01-02"   675
"ALB" "2021-01-03"   447
"ALB" "2021-01-04"   185
"ALB" "2021-01-05"   660
"ALB" "2021-01-06"   725
"ALB" "2021-01-07"   697
"ALB" "2021-01-08"   673
"ALB" "2021-01-09"   655
"ALB" "2021-01-10"   562
"ALB" "2021-01-11"   376
"ALB" "2021-01-12"   656
"ALB" "2021-01-13"   707
"ALB" "2021-01-14"   660
"ALB" "2021-01-15"   641
"ALB" "2021-01-16"   581
"ALB" "2021-01-17"   474
"ALB" "2021-01-18"   292
"ALB" "2021-01-19"   586
"ALB" "2021-01-20"   670
"ALB" "2021-01-21"   678
"ALB" "2021-01-22"   739
"ALB" "2021-01-23"   786
"ALB" "2021-01-24"   833
"ALB" "2021-01-25"   538
"ALB" "2021-01-26"   879
"ALB" "2021-01-27"   876
"ALB" "2021-01-28"   887
"ALB" "2021-01-29"   896
"ALB" "2021-01-30"   901
"ALB" "2021-01-31"   876
"ALB" "2021-02-01"   865
"ALB" "2021-02-02"   942
"ALB" "2021-02-03"  1007
"ALB" "2021-02-04"  1052
"ALB" "2021-02-05"  1089
"ALB" "2021-02-06"  1130
"ALB" "2021-02-07"  1124
"ALB" "2021-02-08"   953
"ALB" "2021-02-09"  1239
"ALB" "2021-02-10"  1143
"ALB" "2021-02-11"  1105
"ALB" "2021-02-12"  1059
"ALB" "2021-02-13"  1152
"ALB" "2021-02-14"  1088
"ALB" "2021-02-15"   775
"ALB" "2021-02-16"   801
"ALB" "2021-02-17"  1075
"ALB" "2021-02-18"  1112
"ALB" "2021-02-19"  1071
"ALB" "2021-02-20"  1153
"ALB" "2021-02-21"  1184
"ALB" "2021-02-22"  1039
"ALB" "2021-02-23"  1021
"ALB" "2021-02-24"  1021
"ALB" "2021-02-25"   986
"ALB" "2021-02-26"   916
"ALB" "2021-02-27"   986
"ALB" "2021-02-28"   952
"ALB" "2021-03-01"   764
"ALB" "2021-03-02"   892
"ALB" "2021-03-03"   851
"ALB" "2021-03-04"   847
"ALB" "2021-03-05"   780
"ALB" "2021-03-06"   777
"ALB" "2021-03-07"   819
"ALB" "2021-03-08"   683
"ALB" "2021-03-09"   629
"ALB" "2021-03-10"   631
"ALB" "2021-03-11"   602
"ALB" "2021-03-12"   681
"ALB" "2021-03-13"   698
"ALB" "2021-03-14"   653
"ALB" "2021-03-15"   543
"ALB" "2021-03-16"   475
"ALB" "2021-03-17"   446
"ALB" "2021-03-18"   590
"ALB" "2021-03-19"   494
"ALB" "2021-03-20"   519
"ALB" "2021-03-21"   659
"ALB" "2021-03-22"   344
"ALB" "2021-03-23"   303
"ALB" "2021-03-24"   448
"ALB" "2021-03-25"   472
"ALB" "2021-03-26"   449
"ALB" "2021-03-27"   425
"ALB" "2021-03-28"   493
"ALB" "2021-03-29"   285
"ALB" "2021-03-30"   304
"ALB" "2021-03-31"   434
"ALB" "2021-04-01"   349
"ALB" "2021-04-02"   336
"ALB" "2021-04-03"   341
"ALB" "2021-04-04"   348
"ALB" "2021-04-05"   264
"ALB" "2021-04-06"   141
"ALB" "2021-04-07"   256
"ALB" "2021-04-08"   317
"ALB" "2021-04-09"   286
"ALB" "2021-04-10"   360
"ALB" "2021-04-11"   238
"ALB" "2021-04-12"   125
"ALB" "2021-04-13"   234
"ALB" "2021-04-14"   207
"ALB" "2021-04-15"   169
"ALB" "2021-04-16"   179
"ALB" "2021-04-17"   149
"ALB" "2021-04-18"   138
"ALB" "2021-04-19"   100
"ALB" "2021-04-20"   148
"ALB" "2021-04-21"   138
"ALB" "2021-04-22"   134
"ALB" "2021-04-23"   156
"ALB" "2021-04-24"   139
"ALB" "2021-04-25"   128
"ALB" "2021-04-26"    69
"ALB" "2021-04-27"   130
"ALB" "2021-04-28"   123
"ALB" "2021-04-29"   118
"ALB" "2021-04-30"   108
end

------------------ copy up to and including the previous line ------------------

Tags: None

Jared Greathouse

Join Date: Sep 2021

Posts: 2170
#2

19 Mar 2022, 11:06

I'm not at my computer right now, and the syntax escapes me, but you'll wanna generate the week variable using (I think, I'm sure Nick Cox will correct me) the week function, and the quarterly variable using the quarter function, and then you'll use the collapse command, summing your number of case variables by nation, week, and quarter.

After I'm home in 20 minutes, assuming nobody's beaten me to the punch, I'll give the syntax
Comment
Nick Cox

Join Date: Mar 2014

Posts: 35219
#3

19 Mar 2022, 11:36

See https://www.statalist.org/forums/for...h-respectively for various comments. I wouldn't reach for the week() function here at all, but I don't have an alternative suggestion until you tell us your definition of a week.
Comment
Moh Bit

Join Date: Oct 2018

Posts: 20
#4

19 Mar 2022, 13:25

Thank you for your responses. Nick: the definition of a week is the sum of COVID-19 cases during seven days (Monday to Sunday).
Comment
Nick Cox

Join Date: Mar 2014

Posts: 35219
#5

19 Mar 2022, 13:44

Weeks start on Monday. See the links and other material in the cited thread for technique
Comment
Moh Bit

Join Date: Oct 2018

Posts: 20
#6

19 Mar 2022, 14:02

I am working on the codes in the link. Thank you, Nick.
Comment

Nick Cox

Join Date: Mar 2014
Posts: 35219

19 Mar 2022, 16:11

Sample code given your data example

Code:

gen ddate = daily(date, "YMD")
format ddate %td 

gen wdate = ddate if dow(ddate) == 1 
format wdate %td 

bysort iso_code (ddate) : replace wdate = wdate[_n-1] if  missing(wdate) 

* partial weeks at beginning 
replace wdate = ddate - 6 if dow(ddate) == 0 & missing(wdate)
replace wdate = ddate + 1 - dow(ddate) if missing(wdate)

egen wanted = total(new_cases), by(iso_code wdate)

tabdisp wdate iso_code, c(wanted)

------------------------
          |   iso_code  
    wdate |   AFG    ALB
----------+-------------
24feb2020 |     5      0
02mar2020 |     3      0
09mar2020 |    12     42
16mar2020 |    16     47
23mar2020 |    80    123
30mar2020 |   185    149
06apr2020 |   256     85
13apr2020 |   378    116
20apr2020 |   530    164
27apr2020 |  1006     69
04may2020 |  1933     73
11may2020 |  2233     78
18may2020 |  4033     52
25may2020 |  4512    139
01jun2020 |  5248    109
08jun2020 |  4424    275
15jun2020 |  4067    441
22jun2020 |  2134    440
29jun2020 |  1984    491
06jul2020 |  1500    561
13jul2020 |  1024    636
20jul2020 |   682    673
27jul2020 |   553    756
03aug2020 |   344    892
10aug2020 |   542    969
17aug2020 |   357   1047
24aug2020 |   190    953
31aug2020 |   255    875
07sep2020 |   318   1098
14sep2020 |   328   1032
21sep2020 |   183    874
28sep2020 |   114   1007
05oct2020 |   458   1133
12oct2020 |   401   1656
19oct2020 |   482   2102
26oct2020 |   657   2045
02nov2020 |   608   3004
09nov2020 |  1002   3624
16nov2020 |  1468   4931
23nov2020 |  1463   4864
30nov2020 |  1675   5363
07dec2020 |  1311   5542
14dec2020 |  1584   4473
21dec2020 |  1312   3251
28dec2020 |   861   3184
04jan2021 |   780   4157
11jan2021 |   495   4095
18jan2021 |   611   4584
25jan2021 |   428   5853
01feb2021 |   312   7209
08feb2021 |   157   7739
15feb2021 |   112   7171
22feb2021 |   110   6921
01mar2021 |   133   5730
08mar2021 |   138   4577
15mar2021 |   118   3726
22mar2021 |   191   2934
29mar2021 |   382   2397
05apr2021 |   484   1862
12apr2021 |   633   1201
19apr2021 |  1050    943
26apr2021 |  1279    548
03may2021 |  1720       
10may2021 |  1642       
17may2021 |  2244       
24may2021 |  5033       
31may2021 |  8463       
07jun2021 | 10637       
14jun2021 | 12045       
21jun2021 | 12314       
28jun2021 | 10528       
05jul2021 |  8830       
12jul2021 |  7024       
19jul2021 |  3269       
26jul2021 |  3630       
02aug2021 |  2957       
09aug2021 |  1575       
16aug2021 |   478       
23aug2021 |   522       
30aug2021 |   390       
06sep2021 |   567       
13sep2021 |   497       
20sep2021 |   473       
27sep2021 |   231       
04oct2021 |   317       
11oct2021 |   256       
18oct2021 |   180       
25oct2021 |   306       
01nov2021 |   147       
08nov2021 |   155       
15nov2021 |   344       
22nov2021 |   322       
29nov2021 |   236       
06dec2021 |   179       
13dec2021 |   154       
20dec2021 |   164       
27dec2021 |   133       
------------------------

Comment

Nick Cox

Join Date: Mar 2014

Posts: 35219
#8

20 Mar 2022, 07:08

Here is more concise code using my https://www.stata-journal.com/articl...article=dm0052

Code:

gen ddate = daily(date, "YMD") gen Wdate = ddate - mod(dow(ddate) - 1, 7) format Wdate ddate %td egen wanted = total(new_cases), by(iso_code Wdate)

The magic constants 7 and 1 are easily explained. 7 is the number of days in a week (you knew that) and 1 is returned by dow() for Mondays. For weeks that start on Sunday Tuesday ... Saturday use 0 2 ... 6 instead.
Comment
Nick Cox

Join Date: Mar 2014

Posts: 35219
#9

20 Mar 2022, 13:11

Correction to previous.

The magic constants 7 and 1 are easily explained. 7 is the number of days in a week (you knew that) and 1 is returned by dow() for Mondays.

For weeks that start on Sunday subtract dow(ddate)

For weeks that start on Tuesday ... Saturday use 2 ... 6 instead of 1.
Comment
Moh Bit

Join Date: Oct 2018

Posts: 20
#10

21 Mar 2022, 03:46

Many thank for this Nick. I appreciate it!
Comment

Announcement

Convert daily sums to weekly sums

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment