Spreadsheet: 83756d1283796978-excel-2007-count-number-of-transaction-in-a-month-when-date-is-entered-also-total-65-bonus-tracker-tms
Sheet: Sheet1

Name | Start Date | DA #1 | Street 1 | close date 1 | Bonus $ 1 | Posted 1 | DA #2 | Street 2 | close date 2 | Bonus $ 2 | Posted 2 | DA #3 | Street 3 | close date 3 | Bonus $ 3 | Posted 3 | DA #4 | Street 4 | close date 4 | Bonus $ 4 | Posted 4 | Total
George | 2010-04-02 00:00:00 | 9451 | Franklin | 2010-01-17 00:00:00 | 128 | 2010-01-19 00:00:00 | 9451 | Franklin | 2010-01-17 00:00:00 | 128 | 2010-01-19 00:00:00 | 9451 | Franklin | 2010-01-17 00:00:00 | 128 | 2010-01-19 00:00:00 | 9469 | Stella | 2010-03-19 00:00:00 | 324 | 2010-03-20 00:00:00
Fred | 2010-01-03 00:00:00 | 9452 | Balley Castle | 2010-02-13 00:00:00 | 345 | 2010-02-13 00:00:00 | 9452 | Balley Castle | 2010-02-13 00:00:00 | 345 | 2010-02-13 00:00:00 | 9452 | Balley Castle | 2010-02-13 00:00:00 | 345 | 2010-02-13 00:00:00 | 9470 | Easy | 2010-10-25 00:00:00 | 111
[NAME] | 2010-07-25 00:00:00 | 9458 | Renfro | 2010-08-23 00:00:00 | 298 | 2010-08-24 00:00:00 | 9458 | Renfro | 2010-08-23 00:00:00 | 298 | 2010-08-24 00:00:00 | 9458 | Renfro | 2010-08-23 00:00:00 | 298 | 2010-08-24 00:00:00 | 9471 | Harvest Hill | 2010-02-15 00:00:00 | 298 | 2010-02-17 00:00:00
[NAME] | 2010-07-03 00:00:00 | 9460 | SW 3rd | 2010-08-28 00:00:00 | 672 | 2010-09-03 00:00:00 | 9460 | SW 3rd | 2010-08-28 00:00:00 | 672 | 2010-09-03 00:00:00 | 9460 | SW 3rd | 2010-08-28 00:00:00 | 672 | 2010-09-03 00:00:00
[NAME] | 2010-05-29 00:00:00 | 9463 | Lions Gate | 2010-07-03 00:00:00 | 111 | 2010-07-03 00:00:00 | 9463 | Lions Gate | 2010-07-03 00:00:00 | 111 | 2010-07-03 00:00:00 | 9463 | Lions Gate | 2010-07-03 00:00:00 | 111 | 2010-07-03 00:00:00
[NAME] | 2010-08-14 00:00:00 | 9465 | [NAME] | 2010-09-22 00:00:00 | 394 |  | 9465 | [NAME] | 2010-09-22 00:00:00 | 394 |  | 9465 | [NAME] | 2010-09-22 00:00:00 | 394
Debbie | 2010-03-05 00:00:00 | 9466 | Saint George | 2010-03-30 00:00:00 | 235 | 2010-03-29 00:00:00 | 9466 | Saint George | 2010-03-30 00:00:00 | 235 | 2010-03-29 00:00:00 | 9466 | Saint George | 2010-03-30 00:00:00 | 235 | 2010-03-29 00:00:00
Jake | 2010-06-05 00:00:00 |  |  | 2010-06-30 00:00:00 |  | 2010-06-30 00:00:00 |  |  | 2010-06-30 00:00:00 |  | 2010-06-30 00:00:00 |  |  | 2010-06-30 00:00:00 |  | 2010-06-30 00:00:00
[NAME] | 2010-02-08 00:00:00 | 9469 | Stella | 2010-03-19 00:00:00 | 324 | 2010-03-20 00:00:00 | 9469 | Stella | 2010-03-19 00:00:00 | 324 | 2010-03-20 00:00:00 | 9469 | Stella | 2010-03-19 00:00:00 | 324 | 2010-03-20 00:00:00
[NAME] | 2010-09-11 00:00:00 | 9470 | Easy | 2010-10-25 00:00:00 | 111 |  | 9470 | Easy | 2010-10-25 00:00:00 | 111 |  | 9470 | Easy | 2010-10-25 00:00:00 | 111
[NAME] | 2010-01-02 00:00:00 | 9471 | Harvest Hill | 2010-02-15 00:00:00 | 298 | 2010-02-17 00:00:00 | 9471 | Harvest Hill | 2010-02-15 00:00:00 | 298 | 2010-02-17 00:00:00 | 9471 | Harvest Hill | 2010-02-15 00:00:00 | 298 | 2010-02-17 00:00:00
George | 2010-04-02 00:00:00 | 9451 | Franklin | 2010-01-17 00:00:00 | 128 | 2011-01-19 00:00:00 | 9451 | Franklin | 2010-01-17 00:00:00 | 128 | 2013-01-19 00:00:00 | 9451 | Franklin | 2010-01-17 00:00:00 | 128 | 2015-01-19 00:00:00 | 9469 | Stella | 2010-03-19 00:00:00 | 324 | 2017-03-20 00:00:00
Fred | 2010-01-03 00:00:00 | 9452 | Balley Castle | 2010-02-13 00:00:00 | 345 | 2011-02-13 00:00:00 | 9452 | Balley Castle | 2010-02-13 00:00:00 | 345 | 2013-02-13 00:00:00 | 9452 | Balley Castle | 2010-02-13 00:00:00 | 345 | 2015-02-13 00:00:00 | 9470 | Easy | 2010-10-25 00:00:00 | 111
[NAME] | 2010-07-25 00:00:00 | 9458 | Renfro | 2010-08-23 00:00:00 | 298 | 2011-08-24 00:00:00 | 9458 | Renfro | 2010-08-23 00:00:00 | 298 | 2013-08-24 00:00:00 | 9458 | Renfro | 2010-08-23 00:00:00 | 298 | 2015-08-24 00:00:00 | 9471 | Harvest Hill | 2010-02-15 00:00:00 | 298 | 2017-02-17 00:00:00
[NAME] | 2010-07-03 00:00:00 | 9460 | SW 3rd | 2010-08-28 00:00:00 | 672 | 2011-09-03 00:00:00 | 9460 | SW 3rd | 2010-08-28 00:00:00 | 672 | 2013-09-03 00:00:00 | 9460 | SW 3rd | 2010-08-28 00:00:00 | 672 | 2015-09-03 00:00:00
[NAME] | 2010-05-29 00:00:00 | 9463 | Lions Gate | 2010-07-03 00:00:00 | 111 | 2011-07-03 00:00:00 | 9463 | Lions Gate | 2010-07-03 00:00:00 | 111 | 2013-07-03 00:00:00 | 9463 | Lions Gate | 2010-07-03 00:00:00 | 111 | 2015-07-03 00:00:00
[NAME] | 2010-08-14 00:00:00 | 9465 | [NAME] | 2010-09-22 00:00:00 | 394 |  | 9465 | [NAME] | 2010-09-22 00:00:00 | 394 |  | 9465 | [NAME] | 2010-09-22 00:00:00 | 394
Debbie | 2010-03-05 00:00:00 | 9466 | Saint George | 2010-03-30 00:00:00 | 235 | 2012-03-29 00:00:00 | 9466 | Saint George | 2010-03-30 00:00:00 | 235 | 2014-03-29 00:00:00 | 9466 | Saint George | 2010-03-30 00:00:00 | 235 | 2016-03-29 00:00:00
Jake | 2010-06-05 00:00:00 |  |  | 2010-06-30 00:00:00 |  | 2012-06-30 00:00:00 |  |  | 2010-06-30 00:00:00 |  | 2014-06-30 00:00:00 |  |  | 2010-06-30 00:00:00 |  | 2016-06-30 00:00:00
[NAME] | 2010-02-08 00:00:00 | 9469 | Stella | 2010-03-19 00:00:00 | 324 | 2012-03-20 00:00:00 | 9469 | Stella | 2010-03-19 00:00:00 | 324 | 2014-03-20 00:00:00 | 9469 | Stella | 2010-03-19 00:00:00 | 324 | 2016-03-20 00:00:00
[NAME] | 2010-09-11 00:00:00 | 9470 | Easy | 2010-10-25 00:00:00 | 111 |  | 9470 | Easy | 2010-10-25 00:00:00 | 111 |  | 9470 | Easy | 2010-10-25 00:00:00 | 111
[NAME] | 2010-01-02 00:00:00 | 9471 | Harvest Hill | 2010-02-15 00:00:00 | 298 | 2012-02-17 00:00:00 | 9471 | Harvest Hill | 2010-02-15 00:00:00 | 298 | 2014-02-17 00:00:00 | 9471 | Harvest Hill | 2010-02-15 00:00:00 | 298 | 2016-02-17 00:00:00
2009 |  |  |  |  | 2010 |  |  |  |  | 2011 |  |  |  |  | 2012 |  |  |  |  | 2013
Month |  | # of closings | Total Bonus |  | Month |  | # of closings | Total Bonus |  | Month |  | # of closings | Total Bonus |  | Month |  | # of closings | Total Bonus |  | Month |  | # of closings | Total Bonus
January |  |  |  |  | January |  |  |  |  | January |  |  |  |  | January |  |  |  |  | January
February |  |  |  |  | February |  |  |  |  | February |  |  |  |  | February |  |  |  |  | February
March |  |  |  |  | March |  |  |  |  | March |  |  |  |  | March |  |  |  |  | March
April |  |  |  |  | April |  |  |  |  | April |  |  |  |  | April |  |  |  |  | April
May |  |  |  |  | May |  |  |  |  | May |  |  |  |  | May |  |  |  |  | May
June |  |  |  |  | June |  |  |  |  | June |  |  |  |  | June |  |  |  |  | June
July |  |  |  |  | July |  |  |  |  | July |  |  |  |  | July |  |  |  |  | July
August |  |  |  |  | August |  |  |  |  | August |  |  |  |  | August |  |  |  |  | August
September |  |  |  |  | September |  |  |  |  | September |  |  |  |  | September |  |  |  |  | September
October |  |  |  |  | October |  |  |  |  | October |  |  |  |  | October |  |  |  |  | October
November |  |  |  |  | November |  |  |  |  | November |  |  |  |  | November |  |  |  |  | November
December |  |  |  |  | December |  |  |  |  | December |  |  |  |  | December |  |  |  |  | December
2014 |  |  |  |  | 2015 |  |  |  |  | 2016 |  |  |  |  | 2017 |  |  |  |  | 2018
Month |  | # of closings | Total Bonus |  | Month |  | # of closings | Total Bonus |  | Month |  | # of closings | Total Bonus |  | Month |  | # of closings | Total Bonus |  | Month |  | # of closings | Total Bonus
January |  |  |  |  | January |  |  |  |  | January |  |  |  |  | January |  |  |  |  | January
February |  |  |  |  | February |  |  |  |  | February |  |  |  |  | February |  |  |  |  | February
March |  |  |  |  | March |  |  |  |  | March |  |  |  |  | March |  |  |  |  | March
April |  |  |  |  | April |  |  |  |  | April |  |  |  |  | April |  |  |  |  | April
May |  |  |  |  | May |  |  |  |  | May |  |  |  |  | May |  |  |  |  | May
June |  |  |  |  | June |  |  |  |  | June |  |  |  |  | June |  |  |  |  | June
July |  |  |  |  | July |  |  |  |  | July |  |  |  |  | July |  |  |  |  | July
August |  |  |  |  | August |  |  |  |  | August |  |  |  |  | August |  |  |  |  | August
September |  |  |  |  | September |  |  |  |  | September |  |  |  |  | September |  |  |  |  | September
October |  |  |  |  | October |  |  |  |  | October |  |  |  |  | October |  |  |  |  | October
November |  |  |  |  | November |  |  |  |  | November |  |  |  |  | November |  |  |  |  | November
December |  |  |  |  | December |  |  |  |  | December |  |  |  |  | December |  |  |  |  | December