Spreadsheet: 74672d1275197458-comparing-figures-over-6-months-sumproduct-example
Sheet: Sheet1

Day | Date | Data | MMM,YY |  |  | May,10
Monday | 2010-03-01 00:00:00 | 56 | Mar,10
Tuesday | 2010-03-02 00:00:00 | 34 | Mar,10
Wednesday | 2010-03-03 00:00:00 | 45 | Mar,10
Thursday | 2010-03-04 00:00:00 | 76 | Mar,10 |  |  |  |  |  | I need the figures for the first 20 bussiness day in April and the same for March
Friday | 2010-03-05 00:00:00 | 23 | Mar,10
Monday | 2010-03-08 00:00:00 | 76 | Mar,10
Tuesday | 2010-03-09 00:00:00 | 32 | Mar,10 |  | Total For May to Date | 997 | Bussiness days elapased | 20
Wednesday | 2010-03-10 00:00:00 | 12 | Mar,10
Thursday | 2010-03-11 00:00:00 | 65 | Mar,10 |  | Total same period April | ?
Friday | 2010-03-12 00:00:00 | 67 | Mar,10
Monday | 2010-03-15 00:00:00 | 20 | Mar,10 |  | Total same period March | ?
Tuesday | 2010-03-16 00:00:00 | 91 | Mar,10
Wednesday | 2010-03-17 00:00:00 | 39 | Mar,10 |  | etc
Thursday | 2010-03-18 00:00:00 | 59 | Mar,10
Friday | 2010-03-19 00:00:00 | 21 | Mar,10 |  | etc
Monday | 2010-03-22 00:00:00 | 88 | Mar,10
Tuesday | 2010-03-23 00:00:00 | 50 | Mar,10 |  | etc
Wednesday | 2010-03-24 00:00:00 | 73 | Mar,10
Thursday | 2010-03-25 00:00:00 | 33 | Mar,10
Friday | 2010-03-26 00:00:00 | 56 | Mar,10
Monday | 2010-03-29 00:00:00 | 93 | Mar,10
Tuesday | 2010-03-30 00:00:00 | 56 | Mar,10
Wednesday | 2010-03-31 00:00:00 | 20 | Mar,10
Thursday | 2010-04-01 00:00:00 | 31 | Apr,10
Friday | 2010-04-02 00:00:00 | 54 | Apr,10
Monday | 2010-04-05 00:00:00 | 75 | Apr,10
Tuesday | 2010-04-06 00:00:00 | 35 | Apr,10
Wednesday | 2010-04-07 00:00:00 | 56 | Apr,10
Thursday | 2010-04-08 00:00:00 | 37 | Apr,10
Friday | 2010-04-09 00:00:00 | 46 | Apr,10
Monday | 2010-04-12 00:00:00 | 32 | Apr,10
Tuesday | 2010-04-13 00:00:00 | 72 | Apr,10
Wednesday | 2010-04-14 00:00:00 | 23 | Apr,10
Thursday | 2010-04-15 00:00:00 | 34 | Apr,10
Friday | 2010-04-16 00:00:00 | 54 | Apr,10
Monday | 2010-04-19 00:00:00 | 23 | Apr,10
Tuesday | 2010-04-20 00:00:00 | 73 | Apr,10
Wednesday | 2010-04-21 00:00:00 | 74 | Apr,10
Thursday | 2010-04-22 00:00:00 | 23 | Apr,10
Friday | 2010-04-23 00:00:00 | 13 | Apr,10
Monday | 2010-04-26 00:00:00 | 12 | Apr,10
Tuesday | 2010-04-27 00:00:00 | 65 | Apr,10
Wednesday | 2010-04-28 00:00:00 | 67 | Apr,10
Thursday | 2010-04-29 00:00:00 | 20 | Apr,10
Friday | 2010-04-30 00:00:00 | 91 | Apr,10
Monday | 2010-05-03 00:00:00 | 39 | May,10
Tuesday | 2010-05-04 00:00:00 | 59 | May,10
Wednesday | 2010-05-05 00:00:00 | 21 | May,10
Thursday | 2010-05-06 00:00:00 | 88 | May,10
Friday | 2010-05-07 00:00:00 | 50 | May,10
Monday | 2010-05-10 00:00:00 | 73 | May,10
Tuesday | 2010-05-11 00:00:00 | 33 | May,10
Wednesday | 2010-05-12 00:00:00 | 56 | May,10
Thursday | 2010-05-13 00:00:00 | 93 | May,10
Friday | 2010-05-14 00:00:00 | 56 | May,10
Monday | 2010-05-17 00:00:00 | 20 | May,10
Tuesday | 2010-05-18 00:00:00 | 31 | May,10
Wednesday | 2010-05-19 00:00:00 | 54 | May,10
Thursday | 2010-05-20 00:00:00 | 75 | May,10
Friday | 2010-05-21 00:00:00 | 35 | May,10
Monday | 2010-05-24 00:00:00 | 56 | May,10
Tuesday | 2010-05-25 00:00:00 | 37 | May,10
Wednesday | 2010-05-26 00:00:00 | 46 | May,10
Thursday | 2010-05-27 00:00:00 | 32 | May,10
Friday | 2010-05-28 00:00:00 | 43 | May,10
Monday | 2010-05-31 00:00:00 |  | May,10