Spreadsheet: 779133d1651596335-formula-that-recognizes-the-amount-of-days-in-a-month-as-we-pull-data-recognize-days-in-month
Sheet: Data

 | Code | Account # | Account Name | Last COB | Currency | Quantity
610202000144621 | 900 | 6102020001 | Example | 2022-03-01 00:00:00 | USD | 132156 | 132156
610202000144622 | 900 | 6102020001 | Example | 2022-03-02 00:00:00 | USD | 4564779 | 4564779
610202000144623 | 900 | 6102020001 | Example | 2022-03-03 00:00:00 | USD | 32154167 | 32154167
610202000144624 | 900 | 6102020001 | Example | 2022-03-04 00:00:00 | USD | 45689 | 45689
610202000144625 | 900 | 6102020001 | Example | 2022-03-05 00:00:00 | USD | 16056694.5 | 16056694.5
610202000144626 | 900 | 6102020001 | Example | 2022-03-06 00:00:00 | USD | 18789693.2 | 18789693.2
610202000144627 | 900 | 6102020001 | Example | 2022-03-07 00:00:00 | USD | 21522691.9 | 21522691.9
610202000144628 | 900 | 6102020001 | Example | 2022-03-08 00:00:00 | USD | 24255690.6 | 24255690.6
610202000144629 | 900 | 6102020001 | Example | 2022-03-09 00:00:00 | USD | 26988689.3 | 26988689.3
610202000144630 | 900 | 6102020001 | Example | 2022-03-10 00:00:00 | USD | 29721688 | 29721688
610202000144633 | 900 | 6102020001 | Example | 2022-03-13 00:00:00 | USD | 37920684.1 | 37920684.1
610202000144634 | 900 | 6102020001 | Example | 2022-03-14 00:00:00 | USD | 40653682.8 | 40653682.8
610202000144635 | 900 | 6102020001 | Example | 2022-03-15 00:00:00 | USD | 43386681.5 | 43386681.5
610202000144636 | 900 | 6102020001 | Example | 2022-03-16 00:00:00 | USD | 46119680.2 | 46119680.2
610202000144637 | 900 | 6102020001 | Example | 2022-03-17 00:00:00 | USD | 48852678.9 | 48852678.9
610202000144638 | 900 | 6102020001 | Example | 2022-03-18 00:00:00 | USD | 51585677.6 | 51585677.6
610202000144639 | 900 | 6102020001 | Example | 2022-03-19 00:00:00 | USD | 54318676.3 | 54318676.3
610202000144642 | 900 | 6102020001 | Example | 2022-03-22 00:00:00 | USD | 62517672.4 | 62517672.4
610202000144643 | 900 | 6102020001 | Example | 2022-03-23 00:00:00 | USD | 65250671.1 | 65250671.1
610202000144644 | 900 | 6102020001 | Example | 2022-03-24 00:00:00 | USD | 67983669.8 | 67983669.8
610202000144645 | 900 | 6102020001 | Example | 2022-03-25 00:00:00 | USD | 70716668.5 | 70716668.5
610202000144646 | 900 | 6102020001 | Example | 2022-03-26 00:00:00 | USD | 73449667.2 | 73449667.2
610202000144647 | 900 | 6102020001 | Example | 2022-03-27 00:00:00 | USD
610202000144648 | 900 | 6102020001 | Example | 2022-03-28 00:00:00 | USD
610202000144649 | 900 | 6102020001 | Example | 2022-03-29 00:00:00 | USD | 81648663.3 | 81648663.3
610202000144650 | 900 | 6102020001 | Example | 2022-03-30 00:00:00 | USD | 84381662 | 84381662
610202000144593 | 900 | 6102020001 | Example | 2022-02-01 00:00:00 |  | 465616 | 465616
610202000144594 | 900 | 6102020001 | Example | 2022-02-02 00:00:00 |  | 3216517 | 3216517
610202000144595 | 900 | 6102020001 | Example | 2022-02-03 00:00:00 |  | 313213 | 313213
610202000144596 | 900 | 6102020001 | Example | 2022-02-04 00:00:00 |  | 1316549 | 1316549
610202000144599 | 900 | 6102020001 | Example | 2022-02-07 00:00:00 |  | 1251886 | 1251886
610202000144600 | 900 | 6102020001 | Example | 2022-02-08 00:00:00 |  | 1233163.4 | 1233163.4
610202000144601 | 900 | 6102020001 | Example | 2022-02-09 00:00:00 |  | 1214440.8 | 1214440.8
610202000144602 | 900 | 6102020001 | Example | 2022-02-10 00:00:00 |  | 1195718.2 | 1195718.2
610202000144603 | 900 | 6102020001 | Example | 2022-02-11 00:00:00 |  | 1176995.6 | 1176995.6
610202000144606 | 900 | 6102020001 | Example | 2022-02-14 00:00:00 |  | 1120827.8 | 1120827.8
610202000144607 | 900 | 6102020001 | Example | 2022-02-15 00:00:00 |  | 1102105.2 | 1102105.2
610202000144608 | 900 | 6102020001 | Example | 2022-02-16 00:00:00 |  | 1083382.6 | 1083382.6
610202000144609 | 900 | 6102020001 | Example | 2022-02-17 00:00:00 |  | 1064660 | 1064660
610202000144610 | 900 | 6102020001 | Example | 2022-02-18 00:00:00 |  | 1045937.4 | 1045937.4
610202000144613 | 900 | 6102020001 | Example | 2022-02-21 00:00:00 |  | 989769.6 | 989769.6
610202000144614 | 900 | 6102020001 | Example | 2022-02-22 00:00:00 |  | 971047 | 971047
610202000144615 | 900 | 6102020001 | Example | 2022-02-23 00:00:00 |  | 952324.4 | 952324.4
610202000144616 | 900 | 6102020001 | Example | 2022-02-24 00:00:00 |  | 933601.8 | 933601.8
610202000144617 | 900 | 6102020001 | Example | 2022-02-25 00:00:00 |  | 914879.2 | 914879.2
610202000144620 | 900 | 6102020001 | Example | 2022-02-28 00:00:00 |  | 858711.4 | 858711.4