Spreadsheet: 48998d1248280355-formula-help-select-a-range-of-dates-within-a-range-of-dates-sample-data
Sheet: Sheet1

FY'08 | 2007-07-01 00:00:00 | 1800
 | 2007-07-02 00:00:00 | 9850 |  | [NAME] YTD
 | 2007-07-02 00:00:00 | 9850 |  | Start Date: | 2009-07-01 00:00:00
 | 2007-07-02 00:00:00 | 790 |  | Today's Date: | 2009-07-22 00:00:00
 | 2007-07-02 00:00:00 | 688
 | 2007-07-02 00:00:00 | 790 |  | FY'08
 | 2007-07-02 00:00:00 | 790 |  | FY'09
 | 2007-07-02 00:00:00 | 790 |  | FY'10
 | 2007-07-02 00:00:00 | 640 |  | AVG:
 | 2007-07-03 00:00:00 | 450
 | 2007-07-10 00:00:00 | 16119
 | 2007-07-13 00:00:00 | 1475
 | 2007-07-20 00:00:00 | 1080
 | 2007-07-25 00:00:00 | 8250
 | 2007-08-01 00:00:00 | 2700
 | 2007-08-15 00:00:00 | 90
 | 2007-08-17 00:00:00 | 250
 | 2007-09-13 00:00:00 | 1700
 | 2007-09-19 00:00:00 | 330
 | 2007-09-21 00:00:00 | 35
 | 2007-09-21 00:00:00 | 180
 | 2007-09-21 00:00:00 | 6200
 | 2007-09-21 00:00:00 | 450
Q1'08 | 2007-09-21 00:00:00 | 10000
[NAME] | 2007-10-02 00:00:00 | 175
 | 2007-10-10 00:00:00 | 4750
 | 2007-10-12 00:00:00 | 16250
 | 2007-12-05 00:00:00 | 790
 | 2007-12-05 00:00:00 | 6500
[NAME] | 2007-12-31 00:00:00 | 129.7
Q3'08 | 2008-01-25 00:00:00 | 2400
 | 2008-02-06 00:00:00 | 6300
 | 2008-02-06 00:00:00 | 200
 | 2008-02-21 00:00:00 | 360
 | 2008-02-22 00:00:00 | 5200
 | 2008-02-22 00:00:00 | 200
 | 2008-02-22 00:00:00 | 6300
 | 2008-02-22 00:00:00 | 200
 | 2008-02-22 00:00:00 | 5200
 | 2008-02-22 00:00:00 | 200
 | 2008-02-29 00:00:00 | 900
 | 2008-03-03 00:00:00 | 606
 | 2008-03-03 00:00:00 | 606
 | 2008-03-03 00:00:00 | 606
 | 2008-03-03 00:00:00 | 250
 | 2008-03-03 00:00:00 | 250
 | 2008-03-03 00:00:00 | 250
 | 2008-03-03 00:00:00 | 250
 | 2008-03-03 00:00:00 | 250
 | 2008-03-03 00:00:00 | 677
 | 2008-03-03 00:00:00 | 250
 | 2008-03-03 00:00:00 | 250
 | 2008-03-03 00:00:00 | 250
 | 2008-03-03 00:00:00 | 250
 | 2008-03-03 00:00:00 | 16375
 | 2008-03-04 00:00:00 | 8302.7
 | 2008-03-04 00:00:00 | 5697.3
 | 2008-03-05 00:00:00 | 3000
 | 2008-03-05 00:00:00 | 180
 | 2008-03-05 00:00:00 | 667
 | 2008-03-05 00:00:00 | 597
 | 2008-03-05 00:00:00 | 804
 | 2008-03-06 00:00:00 | 100
 | 2008-03-06 00:00:00 | 180
 | 2008-03-07 00:00:00 | 250
 | 2008-03-12 00:00:00 | 8250
 | 2008-03-13 00:00:00 | 250
 | 2008-03-13 00:00:00 | 17800
 | 2008-03-25 00:00:00 | 250
 | 2008-03-26 00:00:00 | 6000
 | 2008-03-27 00:00:00 | 17000
 | 2008-03-27 00:00:00 | 6600
Q3'08 | 2008-03-31 00:00:00 | 5200
Q4'08 | 2008-04-09 00:00:00 | 606
 | 2008-04-09 00:00:00 | 1750
 | 2008-04-10 00:00:00 | 1250
 | 2008-04-10 00:00:00 | 625
 | 2008-04-14 00:00:00 | 750
 | 2008-04-17 00:00:00 | 5900
 | 2008-04-17 00:00:00 | 5900
 | 2008-04-17 00:00:00 | 6200
 | 2008-04-28 00:00:00 | 700
 | 2008-04-28 00:00:00 | 700
 | 51/12008 | 6535
 | 2008-05-01 00:00:00 | 180
 | 2008-05-08 00:00:00 | 7186
 | 2008-05-13 00:00:00 | 590
 | 2008-05-15 00:00:00 | 20376.67
 | 2008-05-15 00:00:00 | 433.33
 | 2008-05-23 00:00:00 | 975
 | 2008-05-23 00:00:00 | 65260
 | 2008-05-28 00:00:00 | 1250
 | 2008-06-06 00:00:00 | 4838.59
FY'08 | 2008-06-06 00:00:00 | 950
FY'09 | 2008-07-01 00:00:00 | 1100
 | 2008-07-01 00:00:00 | 1100
 | 2008-07-01 00:00:00 | 1650
 | 2008-07-01 00:00:00 | 1650
 | 2008-07-01 00:00:00 | 11000
 | 2008-07-01 00:00:00 | 1100
 | 2008-07-01 00:00:00 | 1100
 | 2008-07-01 00:00:00 | 1100
 | 2008-07-01 00:00:00 | 4400
 | 2008-07-01 00:00:00 | 3300
 | 2008-07-01 00:00:00 | 1100
 | 2008-07-01 00:00:00 | 6600
 | 2008-07-01 00:00:00 | 2200
 | 2008-07-01 00:00:00 | 1100
 | 2008-07-09 00:00:00 | 670
 | 2008-07-14 00:00:00 | 250
 | 2008-07-14 00:00:00 | 250
 | 2008-07-14 00:00:00 | 250
 | 2008-07-14 00:00:00 | 250
 | 2008-07-14 00:00:00 | 250
 | 2008-07-14 00:00:00 | 250
 | 2008-07-14 00:00:00 | 200
 | 2008-07-14 00:00:00 | 200
 | 2008-07-18 00:00:00 | 2200
 | 2008-07-23 00:00:00 | 36.93
 | 2008-07-25 00:00:00 | 8126.2
 | 2008-08-13 00:00:00 | 2375
 | 2008-08-20 00:00:00 | 3970
 | 2008-08-25 00:00:00 | 1420
 | 2008-09-03 00:00:00 | 1073.5
 | 2008-09-11 00:00:00 | 200
 | 2008-09-11 00:00:00 | 200
 | 2008-09-11 00:00:00 | 200
 | 2008-09-11 00:00:00 | 200
 | 2008-09-11 00:00:00 | 200
 | 2008-09-11 00:00:00 | 200
 | 2008-09-11 00:00:00 | 200
 | 2008-09-11 00:00:00 | 200
 | 2008-09-11 00:00:00 | 200
 | 2008-09-11 00:00:00 | 200
 | 2008-09-15 00:00:00 | 414.15
 | 2008-09-24 00:00:00 | 31000
 | 2008-09-25 00:00:00 | 1637
[NAME] | 2008-09-29 00:00:00 | 83.75
Q2'09 | 2008-10-01 00:00:00 | 18275
 | 2008-10-07 00:00:00 | 9606
 | 2008-10-16 00:00:00 | 250
 | 2008-10-21 00:00:00 | 350
 | 2008-10-23 00:00:00 | 330
 | 2008-10-27 00:00:00 | 11045
 | 2008-10-29 00:00:00 | 190
 | 2008-11-11 00:00:00 | 1205
 | 2008-11-11 00:00:00 | 9820
 | 2008-12-05 00:00:00 | 4253
 | 2008-12-12 00:00:00 | 142.5
Q2'09 | 2008-12-19 00:00:00 | 142.5
Q3'09 | 2009-01-06 00:00:00 | 525
 | 2009-01-13 00:00:00 | 125
 | 2009-01-13 00:00:00 | 679
 | 2009-01-13 00:00:00 | 190
 | 2009-01-13 00:00:00 | 3980
 | 2009-01-13 00:00:00 | 3270
 | 2009-01-15 00:00:00 | 63.17
 | 2009-01-21 00:00:00 | 125
 | 2009-01-21 00:00:00 | 125
 | 2009-01-21 00:00:00 | 125
 | 2009-01-21 00:00:00 | 125
 | 2009-01-21 00:00:00 | 125
 | 2009-01-21 00:00:00 | 125
 | 2009-01-21 00:00:00 | 125
 | 2009-01-21 00:00:00 | 125
 | 2009-01-21 00:00:00 | 125
 | 2009-01-21 00:00:00 | 125
 | 2009-01-21 00:00:00 | 125
 | 2009-01-21 00:00:00 | 125
 | 2009-01-21 00:00:00 | 125
 | 2009-01-21 00:00:00 | 125
 | 2009-01-21 00:00:00 | 125
 | 2009-01-21 00:00:00 | 125
 | 2009-01-21 00:00:00 | 125
 | 2009-01-21 00:00:00 | 125
 | 2009-01-21 00:00:00 | 125
 | 2009-01-21 00:00:00 | 125
 | 2009-01-21 00:00:00 | 125
 | 2009-01-21 00:00:00 | 125
 | 2009-01-21 00:00:00 | 125
 | 2009-01-21 00:00:00 | 677
 | 2009-01-21 00:00:00 | 125
 | 2009-01-21 00:00:00 | 125
 | 2009-01-21 00:00:00 | 125
 | 2009-01-21 00:00:00 | 125
 | 2009-01-13 00:00:00 | 300
 | 2009-01-29 00:00:00 | 190
 | 2009-02-13 00:00:00 | 1073.5
 | 2009-02-20 00:00:00 | 1729.75
 | 2009-02-23 00:00:00 | 3530
 | 2009-03-11 00:00:00 | 6200
 | 2009-03-25 00:00:00 | 7025
 | 2009-03-25 00:00:00 | 7925
Q3'09 | 2009-03-30 00:00:00 | 9200
Q4'09 | 2009-04-06 00:00:00 | 8200
 | 2009-04-07 00:00:00 | 700
 | 2009-04-14 00:00:00 | 28750
 | 2009-04-14 00:00:00 | 190
 | 2009-04-15 00:00:00 | 7525
 | 2009-04-22 00:00:00 | 57.24
 | 2009-04-28 00:00:00 | 125
 | 2009-04-29 00:00:00 | 6375
 | 2009-04-30 00:00:00 | 7625
 | 2009-05-07 00:00:00 | 3100
 | 2009-05-07 00:00:00 | 190
 | 2009-05-08 00:00:00 | 1053.4
 | 2009-05-12 00:00:00 | 1100
 | 2009-05-18 00:00:00 | 612
 | 2009-05-18 00:00:00 | 1053.4
 | 2009-05-26 00:00:00 | 21775
 | 2009-05-29 00:00:00 | 250
 | 2009-05-29 00:00:00 | 804
 | 2009-05-29 00:00:00 | 1815
 | 2009-06-01 00:00:00 | 95
 | 2009-06-09 00:00:00 | 5100
 | 2009-06-12 00:00:00 | 185
 | 2009-06-15 00:00:00 | 200
 | 2009-06-18 00:00:00 | 22625
 | 2009-06-18 00:00:00 | 25850
 | 2009-06-18 00:00:00 | 7005
 | 2009-06-23 00:00:00 | 18200
FY'09 | 2009-06-26 00:00:00 | 1587
FY'10 | 2009-07-09 00:00:00 | 7425
 | 2009-07-09 00:00:00 | 10900
 | 2009-07-09 00:00:00 | 10900
 | 2009-07-10 00:00:00 | 6450