Spreadsheet: 67519d1268138519-sum-calculation-between-two-date-also-inbetween-two-columns-testavk
Sheet: data

INV DATE | OA DATE | AMT
2009-04-04 00:00:00 | 2009-04-03 00:00:00 | 1000
2009-04-10 00:00:00 | 2009-04-09 00:00:00 | 1100
2009-04-10 00:00:00 | 2009-04-09 00:00:00 | 1200
2009-04-10 00:00:00 | 2009-04-09 00:00:00 | 1300
2009-04-13 00:00:00 | 2009-04-13 00:00:00 | 1400
2009-04-16 00:00:00 | 2009-04-16 00:00:00 | 1500
2009-04-15 00:00:00 | 2009-04-15 00:00:00 | 1600
2009-04-15 00:00:00 | 2009-04-15 00:00:00 | 1700
2009-04-15 00:00:00 | 2009-04-15 00:00:00 | 1800
2009-04-18 00:00:00 | 2009-04-13 00:00:00 | 1900
2009-04-18 00:00:00 | 2009-04-17 00:00:00 | 2000
2009-04-18 00:00:00 | 2009-04-17 00:00:00 | 2100
2009-04-20 00:00:00 | 2009-04-20 00:00:00 | 2200
2009-04-24 00:00:00 | 2009-04-21 00:00:00 | 2300
2009-04-24 00:00:00 | 2009-04-21 00:00:00 | 2400
2009-04-24 00:00:00 | 2009-04-21 00:00:00 | 2500
2009-04-24 00:00:00 | 2009-04-21 00:00:00 | 2600
2009-04-18 00:00:00 | 2009-04-14 00:00:00 | 2700
2009-04-28 00:00:00 | 2009-04-27 00:00:00 | 2800
2009-04-28 00:00:00 | 2009-04-27 00:00:00 | 2900
2009-04-28 00:00:00 | 2009-04-27 00:00:00 | 3000
2009-04-28 00:00:00 | 2009-04-27 00:00:00 | 3100
2009-04-28 00:00:00 | 2009-04-27 00:00:00 | 3200
2009-04-28 00:00:00 | 2009-04-27 00:00:00 | 3300
2009-04-28 00:00:00 | 2009-04-27 00:00:00 | 3400
2009-04-28 00:00:00 | 2009-04-27 00:00:00 | 3500
2009-04-28 00:00:00 | 2009-04-27 00:00:00 | 3600
2009-04-28 00:00:00 | 2009-04-27 00:00:00 | 3700
2009-04-26 00:00:00 | 2009-04-24 00:00:00 | 3800
2009-04-26 00:00:00 | 2009-04-24 00:00:00 | 3900
2009-04-27 00:00:00 | 2009-04-13 00:00:00 | 4000
2009-04-27 00:00:00 | 2009-04-13 00:00:00 | 4100
2009-04-27 00:00:00 | 2009-04-13 00:00:00 | 4200
2009-04-27 00:00:00 | 2009-04-13 00:00:00 | 4300
2009-04-27 00:00:00 | 2009-04-14 00:00:00 | 4400
2009-04-27 00:00:00 | 2009-04-14 00:00:00 | 4500
2009-04-27 00:00:00 | 2009-04-13 00:00:00 | 4600
2009-04-27 00:00:00 | 2009-04-13 00:00:00 | 4700
2009-04-27 00:00:00 | 2009-04-13 00:00:00 | 4800
2009-04-27 00:00:00 | 2009-04-13 00:00:00 | 4900
2009-04-27 00:00:00 | 2009-04-13 00:00:00 | 5000
2009-04-27 00:00:00 | 2009-04-13 00:00:00 | 5100
2009-04-26 00:00:00 | 2009-04-14 00:00:00 | 5200
2009-04-26 00:00:00 | 2009-04-14 00:00:00 | 5300
2009-04-26 00:00:00 | 2009-04-14 00:00:00 | 5400
2009-04-26 00:00:00 | 2009-04-14 00:00:00 | 5500
2009-04-26 00:00:00 | 2009-04-14 00:00:00 | 5600
2009-04-26 00:00:00 | 2009-04-14 00:00:00 | 5700
2009-04-26 00:00:00 | 2009-04-14 00:00:00 | 5800
2009-04-26 00:00:00 | 2009-04-14 00:00:00 | 5900
2009-04-26 00:00:00 | 2009-04-17 00:00:00 | 6000
2009-04-27 00:00:00 | 2009-04-14 00:00:00 | 6100
2009-04-27 00:00:00 | 2009-04-14 00:00:00 | 6200
2009-04-27 00:00:00 | 2009-04-14 00:00:00 | 6300
2009-04-29 00:00:00 | 2009-04-28 00:00:00 | 6400 |  | 203500
2009-05-06 00:00:00 | 2009-05-04 00:00:00 | 1111
2009-05-06 00:00:00 | 2009-05-04 00:00:00 | 1211
2009-05-06 00:00:00 | 2009-05-04 00:00:00 | 1311
2009-05-05 00:00:00 | 2009-05-04 00:00:00 | 1411
2009-05-07 00:00:00 | 2009-05-06 00:00:00 | 1511
2009-05-08 00:00:00 | 2009-05-08 00:00:00 | 1611
2009-05-08 00:00:00 | 2009-05-06 00:00:00 | 1711
2009-05-08 00:00:00 | 2009-05-06 00:00:00 | 1811
2009-05-11 00:00:00 | 2009-05-11 00:00:00 | 1911
2009-05-11 00:00:00 | 2009-05-11 00:00:00 | 2011
2009-05-11 00:00:00 | 2009-05-11 00:00:00 | 2111
2009-05-13 00:00:00 | 2009-05-12 00:00:00 | 2211
2009-05-13 00:00:00 | 2009-05-12 00:00:00 | 2311
2009-05-13 00:00:00 | 2009-05-12 00:00:00 | 2411
2009-05-13 00:00:00 | 2009-05-12 00:00:00 | 2511
2009-05-12 00:00:00 | 2009-05-11 00:00:00 | 2611
2009-05-15 00:00:00 | 2009-05-12 00:00:00 | 2711
2009-05-18 00:00:00 | 2009-05-18 00:00:00 | 2811
2009-05-18 00:00:00 | 2009-05-18 00:00:00 | 2911
2009-05-19 00:00:00 | 2009-05-18 00:00:00 | 3011
2009-05-19 00:00:00 | 2009-05-18 00:00:00 | 3111
2009-05-19 00:00:00 | 2009-05-18 00:00:00 | 3211
2009-05-20 00:00:00 | 2009-05-18 00:00:00 | 3311
2009-05-20 00:00:00 | 2009-05-19 00:00:00 | 3411
2009-05-20 00:00:00 | 2009-05-19 00:00:00 | 3511
2009-05-22 00:00:00 | 2009-05-21 00:00:00 | 3611
2009-05-22 00:00:00 | 2009-05-21 00:00:00 | 3711
2009-05-22 00:00:00 | 2009-05-18 00:00:00 | 3811
2009-05-22 00:00:00 | 2009-05-18 00:00:00 | 3911
2009-05-22 00:00:00 | 2009-05-18 00:00:00 | 4011
2009-05-22 00:00:00 | 2009-05-18 00:00:00 | 4111
2009-05-23 00:00:00 | 2009-05-22 00:00:00 | 4211
2009-05-23 00:00:00 | 2009-05-22 00:00:00 | 4311
2009-05-22 00:00:00 | 2009-05-05 00:00:00 | 4411
2009-05-23 00:00:00 | 2009-05-05 00:00:00 | 4511
2009-05-23 00:00:00 | 2009-05-05 00:00:00 | 4611
2009-05-25 00:00:00 | 2009-05-25 00:00:00 | 4711
2009-05-25 00:00:00 | 2009-05-25 00:00:00 | 4811
2009-05-25 00:00:00 | 2009-05-25 00:00:00 | 4911
2009-05-25 00:00:00 | 2009-05-25 00:00:00 | 5011
2009-05-25 00:00:00 | 2009-05-25 00:00:00 | 5111
2009-05-25 00:00:00 | 2009-05-25 00:00:00 | 5211
2009-05-25 00:00:00 | 2009-05-25 00:00:00 | 5311
2009-05-26 00:00:00 | 2009-05-15 00:00:00 | 5411
2009-05-26 00:00:00 | 2009-05-22 00:00:00 | 5511
2009-05-25 00:00:00 | 2009-05-05 00:00:00 | 5611
2009-05-25 00:00:00 | 2009-05-25 00:00:00 | 5711
2009-05-27 00:00:00 | 2009-05-25 00:00:00 | 5811
2009-05-28 00:00:00 | 2009-05-05 00:00:00 | 5911
2009-05-28 00:00:00 | 2009-05-25 00:00:00 | 6011
2009-05-28 00:00:00 | 2009-05-25 00:00:00 | 6111
2009-05-28 00:00:00 | 2009-05-05 00:00:00 | 6211
2009-05-26 00:00:00 | 2009-05-25 00:00:00 | 6311
2009-05-26 00:00:00 | 2009-05-25 00:00:00 | 6411
2009-05-26 00:00:00 | 2009-05-25 00:00:00 | 6511
2009-05-28 00:00:00 | 2009-05-28 00:00:00 | 6611
2009-05-28 00:00:00 | 2009-05-28 00:00:00 | 6711