Spreadsheet: 801495d1666223305-converting-daily-value-to-a-monthly-total-excel-help-v5
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  | Group 2
 |  |  | Group 1 |  |  |  |  |  |  |  |  |  |  | Data_A | Data_B
 |  |  | Date | Data_A | Data_B |  |  |  |  |  |  |  | 2019-01-01 00:00:00
 |  |  | 2019-03-21 00:00:00 | 0.13374 | 0.09588 |  |  |  |  |  |  |  | 2019-02-01 00:00:00
 |  |  | 2019-03-22 00:00:00 | 0.09530000000000001 | 0.09762 |  |  |  |  |  |  |  | 2019-03-01 00:00:00
 |  |  | 2019-03-26 00:00:00 | 0.14346 | 0.123 |  |  |  |  |  |  |  | 2019-04-01 00:00:00
 |  |  | 2019-03-27 00:00:00 | 0.09598000000000002 | 0.1124 |  |  |  |  |  |  |  | 2019-05-01 00:00:00
 |  |  | 2019-03-29 00:00:00 | 0.108115 | 0.09974 |  |  |  |  |  |  |  | 2019-06-01 00:00:00
 |  |  | 2019-04-02 00:00:00 | 0.108115 | 0.09274 |  |  |  |  |  |  |  | 2019-07-01 00:00:00
 |  |  | 2019-04-03 00:00:00 | 0.08059500000000003 | 0.08649 |  |  |  |  |  |  |  | 2019-08-01 00:00:00
 |  |  | 2019-04-05 00:00:00 | 0.10063 | 0.08477 |  |  |  |  |  |  |  | 2019-09-01 00:00:00
 |  |  | 2019-04-10 00:00:00 | 0.09824000000000001 | 0.08062 |  |  |  |  |  |  |  | 2019-10-01 00:00:00
 |  |  | 2019-04-12 00:00:00 | 0.083094 | 0.07901 |  |  |  |  |  |  |  | 2019-11-01 00:00:00
 |  |  | 2019-04-13 00:00:00 | 0.08779300000000001 | 0.07822 |  |  |  |  |  |  |  | 2019-12-01 00:00:00
 |  |  | 2019-04-15 00:00:00 | 0.08134900000000002 | 0.07667 |  |  |  |  |  |  |  | 2020-01-01 00:00:00
 |  |  | 2019-04-18 00:00:00 | 0.08944 | 0.07439 |  |  |  |  |  |  |  | 2020-02-01 00:00:00
 |  |  | 2019-04-22 00:00:00 | 0.08614 | 0.07146 |  |  |  |  |  |  |  | 2020-03-01 00:00:00
 |  |  | 2019-04-23 00:00:00 | 0.079908 | 0.07074 |  |  |  |  |  |  |  | 2020-04-01 00:00:00
 |  |  | 2019-04-30 00:00:00 | 0.128671 | 0.1774 |  |  |  |  |  |  |  | 2020-05-01 00:00:00
 |  |  | 2019-05-02 00:00:00 | 0.126234 | 0.2198 |  |  |  |  |  |  |  | 2020-06-01 00:00:00
 |  |  | 2019-05-03 00:00:00 | 0.10555 | 0.2068 |  |  |  |  |  |  |  | 2020-07-01 00:00:00
 |  |  | 2019-05-06 00:00:00 | 0.09856800000000002 | 0.1359 |  |  |  |  |  |  |  | 2020-08-01 00:00:00
 |  |  | 2019-05-09 00:00:00 | 0.094178 | 0.1125 |  |  |  |  |  |  |  | 2020-09-01 00:00:00
 |  |  | 2019-05-10 00:00:00 | 0.08724200000000001 | 0.1085 |  |  |  |  |  |  |  | 2020-10-01 00:00:00
 |  |  | 2019-05-13 00:00:00 | 0.09456899999999999 | 0.105 |  |  |  |  |  |  |  | 2020-11-01 00:00:00
 |  |  | 2019-05-14 00:00:00 | 0.091758 | 0.09863 |  |  |  |  |  |  |  | 2020-12-01 00:00:00
 |  |  | 2019-05-17 00:00:00 | 0.086912 | 0.09878
 |  |  | 2019-05-22 00:00:00 | 0.08556499999999999 | 0.09181
 |  |  | 2019-05-24 00:00:00 | 0.10078 | 0.1133
 |  |  | 2019-06-07 00:00:00 | 0.09154 | 0.08306
 |  |  | 2019-06-08 00:00:00 | 0.09138 | 0.08223
 |  |  | 2019-06-10 00:00:00 | 0.087282 | 0.08059 |  |  | Target
 |  |  | 2019-06-14 00:00:00 | 0.076285 | 0.07741
 |  |  | 2019-06-17 00:00:00 | 0.0872 | 0.07511 |  |  |  | I have daily data value as indicated in Group 1 and I want to do a montly total and fill in data Group 2 throught using excel formular
 |  |  | 2019-06-19 00:00:00 | 0.07951 | 0.07362 |  |  |  | For the montth that is no data I want to return as NA
 |  |  | 2019-06-24 00:00:00 | 0.10638 | 0.1627
 |  |  | 2019-06-26 00:00:00 | 0.08625 | 0.1203 |  |  |  | Thanks you :)
 |  |  | 2019-06-29 00:00:00 | 0.08162349999999999 | 0.09458
 |  |  | 2019-07-01 00:00:00 | 0.079299 | 0.08741
 |  |  | 2019-07-04 00:00:00 | 0.070785 | 0.08048
 |  |  | 2019-07-06 00:00:00 | 0.08521000000000002 | 0.07888
 |  |  | 2019-07-09 00:00:00 | 0.076815 | 0.07653
 |  |  | 2019-07-12 00:00:00 | 0.07864499999999999 | 0.07426
 |  |  | 2019-07-13 00:00:00 | 0.07816499999999998 | 0.07352
 |  |  | 2019-07-16 00:00:00 | 0.07365 | 0.07134
 |  |  | 2019-07-18 00:00:00 | 0.07963500000000001 | 0.06992
 |  |  | 2019-07-19 00:00:00 | 0.08066999999999999 | 0.06922
 |  |  | 2019-07-22 00:00:00 | 0.072 | 0.06716
 |  |  | 2019-07-27 00:00:00 | 0.07944999999999999 | 0.06387
 |  |  | 2019-08-01 00:00:00 | 0.08858500000000001 | 0.06074
 |  |  | 2019-08-03 00:00:00 | 0.085885 | 0.05953
 |  |  | 2019-08-06 00:00:00 | 0.08455999999999998 | 0.05776
 |  |  | 2019-08-07 00:00:00 | 0.0881825 | 0.05718
 |  |  | 2019-08-12 00:00:00 | 0.08287 | 0.05438
 |  |  | 2019-08-14 00:00:00 | 0.08567999999999999 | 0.0533
 |  |  | 2019-08-16 00:00:00 | 0.08992000000000001 | 0.05224
 |  |  | 2019-08-19 00:00:00 | 0.08722500000000002 | 0.05069
 |  |  | 2019-08-22 00:00:00 | 0.0761025 | 0.04918
 |  |  | 2019-08-24 00:00:00 | 0.07329999999999999 | 0.0482
 |  |  | 2019-08-26 00:00:00 | 0.073985 | 0.04724
 |  |  | 2019-08-28 00:00:00 | 0.07493400000000001 | 0.0463
 |  |  | 2019-08-30 00:00:00 | 0.074055 | 0.04538
 |  |  | 2019-09-02 00:00:00 | 0.0678 | 0.04403
 |  |  | 2019-09-04 00:00:00 | 0.06589 | 0.04316
 |  |  | 2019-09-06 00:00:00 | 0.07299 | 0.0423
 |  |  | 2019-09-09 00:00:00 | 0.07460750000000001 | 0.04104
 |  |  | 2019-09-13 00:00:00 | 0.06252 | 0.03943
 |  |  | 2019-09-14 00:00:00 | 0.07903 | 0.03903
 |  |  | 2019-09-17 00:00:00 | 0.07833000000000001 | 0.03787
 |  |  | 2019-09-20 00:00:00 | 0.07589 | 0.03675
 |  |  | 2019-09-23 00:00:00 | 0.0649 | 0.03566
 |  |  | 2019-09-27 00:00:00 | 0.07428 | 0.03425
 |  |  | 2019-09-28 00:00:00 | 0.07988 | 0.03391
 |  |  | 2019-09-30 00:00:00 | 0.07074000000000001 | 0.03323
 |  |  | 2019-10-02 00:00:00 | 0.074006 | 0.03257
 |  |  | 2019-10-03 00:00:00 | 0.15538 | 0.1319
 |  |  | 2019-10-08 00:00:00 | 0.07825500000000002 | 0.05603
 |  |  | 2019-10-09 00:00:00 | 0.07087874999999999 | 0.05179
 |  |  | 2019-10-11 00:00:00 | 0.0657225 | 0.04668
 |  |  | 2019-10-14 00:00:00 | 0.076755 | 0.04194
 |  |  | 2019-10-16 00:00:00 | 0.06682500000000001 | 0.04111
 |  |  | 2019-10-18 00:00:00 | 0.0678375 | 0.04029
 |  |  | 2019-10-22 00:00:00 | 0.0644025 | 0.0387
 |  |  | 2019-10-23 00:00:00 | 0.06675900000000001 | 0.03831
 |  |  | 2019-10-26 00:00:00 | 0.06554249999999999 | 0.03718
 |  |  | 2019-10-28 00:00:00 | 0.06552 | 0.03644
 |  |  | 2019-10-31 00:00:00 | 0.0645375 | 0.03535
 |  |  | 2019-11-01 00:00:00 | 0.06465 | 0.035
 |  |  | 2019-11-05 00:00:00 | 0.06264 | 0.03362
 |  |  | 2019-11-06 00:00:00 | 0.0648375 | 0.03329
 |  |  | 2019-11-08 00:00:00 | 0.06282750000000001 | 0.03262
 |  |  | 2019-11-12 00:00:00 | 0.0648225 | 0.03134
 |  |  | 2019-11-13 00:00:00 | 0.06764250000000001 | 0.03102
 |  |  | 2019-11-15 00:00:00 | 0.05907 | 0.03041
 |  |  | 2019-11-18 00:00:00 | 0.0692325 | 0.03933
 |  |  | 2019-11-19 00:00:00 | 0.06759 | 0.03643
 |  |  | 2019-11-21 00:00:00 | 0.06501000000000001 | 0.03291
 |  |  | 2019-11-25 00:00:00 | 0.05964000000000001 | 0.02935
 |  |  | 2019-11-27 00:00:00 | 0.07104750000000001 | 0.04598
 |  |  | 2019-11-29 00:00:00 | 0.06177000000000001 | 0.03726
 |  |  | 2019-12-02 00:00:00 | 0.05874000000000001 | 0.03577
 |  |  | 2019-12-03 00:00:00 | 0.0609825 | 0.02946
 |  |  | 2019-12-10 00:00:00 | 0.06493650000000001 | 0.02746
 |  |  | 2019-12-12 00:00:00 | 0.06334799999999999 | 0.02691
 |  |  | 2019-12-13 00:00:00 | 0.07281 | 0.02895
 |  |  | 2019-12-18 00:00:00 | 0.05725 | 0.02546
 |  |  | 2019-12-19 00:00:00 | 0.06036999999999999 | 0.0252
 |  |  | 2019-12-20 00:00:00 | 0.05721000000000001 | 0.02495
 |  |  | 2019-12-23 00:00:00 | 0.06693 | 0.02421
 |  |  | 2019-12-27 00:00:00 | 0.0819 | 0.04513
 |  |  | 2019-12-28 00:00:00 | 0.10341 | 0.05882
 |  |  | 2019-12-30 00:00:00 | 0.07257999999999999 | 0.04626
 |  |  | 2020-01-03 00:00:00 | 0.09716000000000001 | 0.03168
 |  |  | 2020-01-04 00:00:00 | 0.08669 | 0.03027
 |  |  | 2020-01-07 00:00:00 | 0.13541 | 0.03624
 |  |  | 2020-01-09 00:00:00 | 0.126932 | 0.08942
 |  |  | 2020-01-10 00:00:00 | 0.10004 | 0.07261
 |  |  | 2020-01-13 00:00:00 | 0.052136 | 0.04814
 |  |  | 2020-01-17 00:00:00 | 0.059076 | 0.04513
 |  |  | 2020-01-20 00:00:00 | 0.101265 | 0.1146
 |  |  | 2020-01-22 00:00:00 | 0.077679 | 0.07689
 |  |  | 2020-01-29 00:00:00 | 0.09963599999999999 | 0.1037
 |  |  | 2020-01-31 00:00:00 | 0.0765885 | 0.09463
 |  |  | 2020-02-05 00:00:00 | 0.0685185 | 0.06728
 |  |  | 2020-02-06 00:00:00 | 0.062655 | 0.06298
 |  |  | 2020-02-07 00:00:00 | 0.064932 | 0.05993
 |  |  | 2020-02-10 00:00:00 | 0.06078000000000001 | 0.05785
 |  |  | 2020-02-12 00:00:00 | 0.0686925 | 0.05216
 |  |  | 2020-02-14 00:00:00 | 0.0642975 | 0.05112
 |  |  | 2020-02-17 00:00:00 | 0.07677 | 0.0496
 |  |  | 2020-02-18 00:00:00 | 0.07489199999999999 | 0.0491
 |  |  | 2020-02-24 00:00:00 | 0.0656745 | 0.04623
 |  |  | 2020-03-03 00:00:00 | 0.11994 | 0.1431
 |  |  | 2020-03-04 00:00:00 | 0.1113525 | 0.1242
 |  |  | 2020-03-09 00:00:00 | 0.09781799999999999 | 0.1104