Spreadsheet: 476955d1472079107-business-count-growth-net-biz-openings-example
Sheet: Sheet1

[NAME] | Open Date | Close Date | Open Year | Open Month | Close Month | Close Month |  | I used these just to create fake data |  |  | Open Year | Open Month |  |  | Open Date | Openings | Closings | Net Change
Biz Name1 | 2011-01-09 00:00:00 |  |  |  |  |  |  | Start Date Gap | 20 |  | 2011 | 1
[NAME] | 2011-01-29 00:00:00 | 2012-03-04 00:00:00 |  |  |  |  |  | Close Date Gap | 400 |  | 2011 | 2
[NAME] | 2011-02-03 00:00:00 |  |  |  |  |  |  |  |  |  | 2011 | 3
[NAME] | 2011-02-13 00:00:00 |  |  |  |  |  |  |  |  |  | 2011 | 4
[NAME] | 2011-02-28 00:00:00 | 2012-04-03 00:00:00 |  |  |  |  |  |  |  |  | 2011 | 5
Biz Name6 | 2011-03-17 00:00:00 | 2012-04-20 00:00:00 |  |  |  |  |  |  |  |  | 2011 | 6
Biz Name7 | 2011-04-06 00:00:00 | 2012-05-10 00:00:00 |  |  |  |  |  |  |  |  | 2011 | 7
Biz Name8 | 2011-04-21 00:00:00 |  |  |  |  |  |  |  |  |  | 2011 | 8
[NAME] | 2011-04-25 00:00:00 | 2012-05-29 00:00:00 |  |  |  |  |  |  |  |  | 2011 | 9
[NAME] | 2011-05-15 00:00:00 | 2012-06-18 00:00:00 |  |  |  |  |  |  |  |  | 2011 | 10
[NAME] | 2011-06-03 00:00:00 | 2012-07-07 00:00:00 |  |  |  |  |  |  |  |  | 2011 | 11
Biz Name12 | 2011-06-13 00:00:00 | 2012-07-17 00:00:00 |  |  |  |  |  |  |  |  | 2011 | 12
Biz Name13 | 2011-06-29 00:00:00 |  |  |  |  |  |  |  |  |  | 2012 | 1
[NAME] | 2011-07-10 00:00:00 |  |  |  |  |  |  |  |  |  | 2012 | 2
[NAME] | 2011-07-22 00:00:00 |  |  |  |  |  |  |  |  |  | 2012 | 3
[NAME] | 2011-07-28 00:00:00 |  |  |  |  |  |  |  |  |  | 2012 | 4
Biz Name17 | 2011-08-01 00:00:00 |  |  |  |  |  |  |  |  |  | 2012 | 5
Biz Name18 | 2011-08-11 00:00:00 |  |  |  |  |  |  |  |  |  | 2012 | 6
Biz Name19 | 2011-08-23 00:00:00 |  |  |  |  |  |  |  |  |  | 2012 | 7
[NAME] | 2011-08-25 00:00:00 |  |  |  |  |  |  |  |  |  | 2012 | 8
Biz Name21 | 2011-09-01 00:00:00 | 2012-10-05 00:00:00 |  |  |  |  |  |  |  |  | 2012 | 9
[NAME] | 2011-09-09 00:00:00 | 2012-10-13 00:00:00 |  |  |  |  |  |  |  |  | 2012 | 10
[NAME] | 2011-09-10 00:00:00 |  |  |  |  |  |  |  |  |  | 2012 | 11
[NAME] | 2011-09-26 00:00:00 |  |  |  |  |  |  |  |  |  | 2012 | 12
[NAME] | 2011-10-05 00:00:00 | 2012-11-08 00:00:00 |  |  |  |  |  |  |  |  | 2013 | 1
[NAME] | 2011-10-09 00:00:00 | 2012-11-12 00:00:00 |  |  |  |  |  |  |  |  | 2013 | 2
Biz Name27 | 2011-10-23 00:00:00 | 2012-11-26 00:00:00 |  |  |  |  |  |  |  |  | 2013 | 3
[NAME] | 2011-10-26 00:00:00 |  |  |  |  |  |  |  |  |  | 2013 | 4
Biz Name29 | 2011-11-03 00:00:00 | 2012-12-07 00:00:00 |  |  |  |  |  |  |  |  | 2013 | 5
Biz Name30 | 2011-11-15 00:00:00 |  |  |  |  |  |  |  |  |  | 2013 | 6
[NAME] | 2011-11-16 00:00:00 |  |  |  |  |  |  |  |  |  | 2013 | 7
Biz Name32 | 2011-11-23 00:00:00 |  |  |  |  |  |  |  |  |  | 2013 | 8
[NAME] | 2011-12-03 00:00:00 | 2013-01-06 00:00:00 |  |  |  |  |  |  |  |  | 2013 | 9
[NAME] | 2011-12-11 00:00:00 |  |  |  |  |  |  |  |  |  | 2013 | 10
Biz Name35 | 2011-12-24 00:00:00 |  |  |  |  |  |  |  |  |  | 2013 | 11
[NAME] | 2012-01-05 00:00:00 | 2013-02-08 00:00:00 |  |  |  |  |  |  |  |  | 2013 | 12
Biz Name37 | 2012-01-09 00:00:00 |  |  |  |  |  |  |  |  |  | 2014 | 1
[NAME] | 2012-01-17 00:00:00 | 2013-02-20 00:00:00 |  |  |  |  |  |  |  |  | 2014 | 2
[NAME] | 2012-02-04 00:00:00 | 2013-03-10 00:00:00 |  |  |  |  |  |  |  |  | 2014 | 3
Biz Name40 | 2012-02-18 00:00:00 |  |  |  |  |  |  |  |  |  | 2014 | 4
Biz Name41 | 2012-03-08 00:00:00 | 2013-04-12 00:00:00 |  |  |  |  |  |  |  |  | 2014 | 5
Biz Name42 | 2012-03-15 00:00:00 |  |  |  |  |  |  |  |  |  | 2014 | 6
Biz Name43 | 2012-03-24 00:00:00 |  |  |  |  |  |  |  |  |  | 2014 | 7
Biz Name44 | 2012-03-31 00:00:00 | 2013-05-05 00:00:00 |  |  |  |  |  |  |  |  | 2014 | 8
Biz Name45 | 2012-04-04 00:00:00 | 2013-05-09 00:00:00 |  |  |  |  |  |  |  |  | 2014 | 9
[NAME] | 2012-04-14 00:00:00 |  |  |  |  |  |  |  |  |  | 2014 | 10
[NAME] | 2012-04-15 00:00:00 |  |  |  |  |  |  |  |  |  | 2014 | 11
Biz Name48 | 2012-05-01 00:00:00 | 2013-06-05 00:00:00 |  |  |  |  |  |  |  |  | 2014 | 12
Biz Name49 | 2012-05-14 00:00:00 | 2013-06-18 00:00:00 |  |  |  |  |  |  |  |  | 2015 | 1
Biz Name50 | 2012-05-22 00:00:00 | 2013-06-26 00:00:00 |  |  |  |  |  |  |  |  | 2015 | 2
[NAME] | 2012-06-01 00:00:00 |  |  |  |  |  |  |  |  |  | 2015 | 3
[NAME] | 2012-06-13 00:00:00 |  |  |  |  |  |  |  |  |  | 2015 | 4
[NAME] | 2012-06-18 00:00:00 | 2013-07-23 00:00:00 |  |  |  |  |  |  |  |  | 2015 | 5
Biz Name54 | 2012-06-28 00:00:00 | 2013-08-02 00:00:00 |  |  |  |  |  |  |  |  | 2015 | 6
[NAME] | 2012-07-14 00:00:00 | 2013-08-18 00:00:00 |  |  |  |  |  |  |  |  | 2015 | 7
Biz Name56 | 2012-07-31 00:00:00 | 2013-09-04 00:00:00 |  |  |  |  |  |  |  |  | 2015 | 8
[NAME] | 2012-08-14 00:00:00 |  |  |  |  |  |  |  |  |  | 2015 | 9
[NAME] | 2012-08-29 00:00:00 |  |  |  |  |  |  |  |  |  | 2015 | 10
Biz Name59 | 2012-09-08 00:00:00 | 2013-10-13 00:00:00 |  |  |  |  |  |  |  |  | 2015 | 11
Biz Name60 | 2012-09-21 00:00:00 |  |  |  |  |  |  |  |  |  | 2015 | 12
Biz Name61 | 2012-10-06 00:00:00 | 2013-11-10 00:00:00 |  |  |  |  |  |  |  |  | 2016 | 1
Biz Name62 | 2012-10-15 00:00:00 |  |  |  |  |  |  |  |  |  | 2016 | 2
[NAME] | 2012-10-20 00:00:00 |  |  |  |  |  |  |  |  |  | 2016 | 3
[NAME] | 2012-10-24 00:00:00 | 2013-11-28 00:00:00 |  |  |  |  |  |  |  |  | 2016 | 4
Biz Name65 | 2012-11-08 00:00:00 |  |  |  |  |  |  |  |  |  | 2016 | 5
Biz Name66 | 2012-11-16 00:00:00 |  |  |  |  |  |  |  |  |  | 2016 | 6
Biz [NAME] | 2012-11-24 00:00:00 |  |  |  |  |  |  |  |  |  | 2016 | 7
[NAME] | 2012-11-29 00:00:00 |  |  |  |  |  |  |  |  |  | 2016 | 8
[NAME] | 2012-12-03 00:00:00 | 2014-01-07 00:00:00 |  |  |  |  |  |  |  |  | Grand Total
[NAME] | 2012-12-11 00:00:00
Biz Name71 | 2012-12-30 00:00:00 | 2014-02-03 00:00:00
[NAME] | 2013-01-17 00:00:00 | 2014-02-21 00:00:00
[NAME] | 2013-01-22 00:00:00 | 2014-02-26 00:00:00
[NAME] | 2013-01-26 00:00:00
[NAME] | 2013-02-15 00:00:00 | 2014-03-22 00:00:00
Biz Name76 | 2013-02-19 00:00:00 | 2014-03-26 00:00:00
Biz Name77 | 2013-03-04 00:00:00
Biz Name78 | 2013-03-05 00:00:00
Biz Name79 | 2013-03-07 00:00:00 | 2014-04-11 00:00:00
Biz Name80 | 2013-03-13 00:00:00 | 2014-04-17 00:00:00
Biz Name81 | 2013-03-18 00:00:00
[NAME] | 2013-03-23 00:00:00 | 2014-04-27 00:00:00
[NAME] | 2013-04-05 00:00:00
[NAME] | 2013-04-19 00:00:00 | 2014-05-24 00:00:00
[NAME] | 2013-05-06 00:00:00 | 2014-06-10 00:00:00
Biz Name86 | 2013-05-14 00:00:00 | 2014-06-18 00:00:00
Biz Name87 | 2013-05-27 00:00:00
[NAME] | 2013-06-05 00:00:00 | 2014-07-10 00:00:00
Biz Name89 | 2013-06-18 00:00:00 | 2014-07-23 00:00:00
[NAME] | 2013-06-24 00:00:00
Biz Name91 | 2013-06-30 00:00:00 | 2014-08-04 00:00:00
[NAME] | 2013-07-15 00:00:00 | 2014-08-19 00:00:00
Biz Name93 | 2013-07-21 00:00:00 | 2014-08-25 00:00:00
[NAME] | 2013-08-04 00:00:00 | 2014-09-08 00:00:00
Biz Name95 | 2013-08-17 00:00:00
Biz Name96 | 2013-08-28 00:00:00 | 2014-10-02 00:00:00
[NAME] | 2013-09-17 00:00:00
Biz Name98 | 2013-10-07 00:00:00 | 2014-11-11 00:00:00
[NAME] | 2013-10-19 00:00:00 | 2014-11-23 00:00:00
Biz Name100 | 2013-11-01 00:00:00 | 2014-12-06 00:00:00
[NAME] | 2013-11-17 00:00:00
Biz Name102 | 2013-11-28 00:00:00 | 2015-01-02 00:00:00
Biz Name103 | 2013-12-18 00:00:00 | 2015-01-22 00:00:00
Biz Name104 | 2013-12-26 00:00:00 | 2015-01-30 00:00:00
[NAME] | 2014-01-04 00:00:00
[NAME] | 2014-01-18 00:00:00
[NAME] | 2014-01-25 00:00:00 | 2015-03-01 00:00:00
Biz Name108 | 2014-01-28 00:00:00 | 2015-03-04 00:00:00
Biz Name109 | 2014-02-08 00:00:00
[NAME] | 2014-02-11 00:00:00
[NAME] | 2014-02-17 00:00:00 | 2015-03-24 00:00:00
[NAME] | 2014-03-08 00:00:00 | 2015-04-12 00:00:00
[NAME] | 2014-03-15 00:00:00
[NAME] | 2014-03-24 00:00:00 | 2015-04-28 00:00:00
[NAME] | 2014-04-11 00:00:00 | 2015-05-16 00:00:00
[NAME] | 2014-04-16 00:00:00 | 2015-05-21 00:00:00
[NAME] | 2014-04-17 00:00:00
[NAME] | 2014-04-29 00:00:00
[NAME] | 2014-05-06 00:00:00
Biz Name120 | 2014-05-13 00:00:00 | 2015-06-17 00:00:00
[NAME] | 2014-05-21 00:00:00
[NAME] | 2014-05-25 00:00:00
Biz Name123 | 2014-06-11 00:00:00 | 2015-07-16 00:00:00
[NAME] | 2014-06-20 00:00:00
Biz Name125 | 2014-07-03 00:00:00
Biz Name126 | 2014-07-17 00:00:00
[NAME] | 2014-08-05 00:00:00 | 2015-09-09 00:00:00
[NAME] | 2014-08-12 00:00:00
Biz Name129 | 2014-08-31 00:00:00 | 2015-10-05 00:00:00
Biz Name130 | 2014-09-01 00:00:00 | 2015-10-06 00:00:00
Biz Name131 | 2014-09-09 00:00:00 | 2015-10-14 00:00:00
[NAME] | 2014-09-16 00:00:00 | 2015-10-21 00:00:00
Biz Name133 | 2014-09-26 00:00:00
Biz Name134 | 2014-10-04 00:00:00
Biz Name135 | 2014-10-18 00:00:00
Biz Name136 | 2014-11-02 00:00:00 | 2015-12-07 00:00:00
[NAME] | 2014-11-07 00:00:00 | 2015-12-12 00:00:00
[NAME] | 2014-11-08 00:00:00 | 2015-12-13 00:00:00
Biz Name139 | 2014-11-23 00:00:00
Biz Name140 | 2014-12-09 00:00:00
[NAME] | 2014-12-29 00:00:00
Biz Name142 | 2015-01-14 00:00:00
[NAME] | 2015-01-25 00:00:00
[NAME] | 2015-02-10 00:00:00 | 2016-03-16 00:00:00
[NAME] | 2015-02-23 00:00:00
Biz Name146 | 2015-02-28 00:00:00
[NAME] | 2015-03-12 00:00:00
Biz Name148 | 2015-03-31 00:00:00 | 2016-05-04 00:00:00
Biz Name149 | 2015-04-17 00:00:00 | 2016-05-21 00:00:00
Biz Name150 | 2015-04-30 00:00:00 | 2016-06-03 00:00:00
[NAME] | 2015-05-17 00:00:00 | 2016-06-20 00:00:00
Biz Name152 | 2015-05-21 00:00:00 | 2016-06-24 00:00:00
[NAME] | 2015-05-27 00:00:00
[NAME] | 2015-06-11 00:00:00
[NAME] | 2015-06-30 00:00:00
[NAME] | 2015-07-20 00:00:00 | 2016-08-23 00:00:00
[NAME] | 2015-08-09 00:00:00
Biz Name158 | 2015-08-16 00:00:00
[NAME] | 2015-08-31 00:00:00 | 2016-10-04 00:00:00
Biz Name160 | 2015-09-06 00:00:00 | 2016-10-10 00:00:00
Biz Name161 | 2015-09-09 00:00:00 | 2016-10-13 00:00:00
[NAME] | 2015-09-17 00:00:00
[NAME] | 2015-09-20 00:00:00 | 2016-10-24 00:00:00
[NAME] | 2015-09-27 00:00:00
[NAME] | 2015-10-07 00:00:00
Biz Name166 | 2015-10-20 00:00:00
[NAME] | 2015-10-24 00:00:00 | 2016-11-27 00:00:00
[NAME] | 2015-11-08 00:00:00
[NAME] | 2015-11-18 00:00:00
[NAME] | 2015-11-27 00:00:00 | 2016-12-31 00:00:00
Biz Name171 | 2015-12-08 00:00:00
[NAME] | 2015-12-10 00:00:00 | 2017-01-13 00:00:00
[NAME] | 2015-12-21 00:00:00
[NAME] | 2016-01-07 00:00:00
[NAME] | 2016-01-23 00:00:00 | 2017-02-26 00:00:00
[NAME] | 2016-02-11 00:00:00 | 2017-03-17 00:00:00
Biz Name177 | 2016-02-27 00:00:00 | 2017-04-02 00:00:00
[NAME] | 2016-02-29 00:00:00
Biz Name179 | 2016-03-03 00:00:00 | 2017-04-07 00:00:00
[NAME] | 2016-03-05 00:00:00
[NAME] | 2016-03-19 00:00:00
[NAME] | 2016-03-28 00:00:00
Biz Name183 | 2016-04-05 00:00:00
Biz Name184 | 2016-04-13 00:00:00
[NAME] | 2016-04-26 00:00:00
[NAME] | 2016-04-29 00:00:00 | 2017-06-03 00:00:00
Biz Name187 | 2016-05-12 00:00:00
[NAME] | 2016-05-18 00:00:00 | 2017-06-22 00:00:00
[NAME] | 2016-05-27 00:00:00 | 2017-07-01 00:00:00
Biz Name190 | 2016-06-07 00:00:00 | 2017-07-12 00:00:00
[NAME] | 2016-06-17 00:00:00 | 2017-07-22 00:00:00
Biz Name192 | 2016-07-05 00:00:00
[NAME] | 2016-07-07 00:00:00 | 2017-08-11 00:00:00
Biz Name194 | 2016-07-11 00:00:00
[NAME] | 2016-07-20 00:00:00
[NAME] | 2016-07-22 00:00:00
[NAME] | 2016-08-09 00:00:00
Biz Name198 | 2016-08-10 00:00:00 | 2017-09-14 00:00:00
[NAME] | 2016-08-16 00:00:00 | 2017-09-20 00:00:00
[NAME] | 2016-08-24 00:00:00 | 2017-09-28 00:00:00