Spreadsheet: 673897d1587580187-help-calculating-lost-customers-over-multiple-months-client-revenue-report-vforum
Sheet: Customer Count

 |  | Customer # | Start Date | Term Date |  |  | 2008-12-31 00:00:00 | 2009-01-31 00:00:00
 |  | 1 | 2014-03-01 00:00:00 | 2021-01-31 00:00:00
 |  | 2 | 2012-07-01 00:00:00 | 2017-07-31 00:00:00
 |  | 3 | 2011-09-01 00:00:00 | 2011-11-30 00:00:00
 |  | 4 | 2009-10-01 00:00:00 | 2012-09-30 00:00:00
 |  | 6 | 2009-07-01 00:00:00 | 2011-06-30 00:00:00
 |  | 7 | 2017-04-01 00:00:00 | 2020-03-31 00:00:00
 |  | 8 | 2014-12-01 00:00:00 | 2016-01-31 00:00:00
 |  | 9 | 2018-08-01 00:00:00 | 2019-07-31 00:00:00
 |  | 10 | 2019-12-01 00:00:00 | 2020-02-29 00:00:00
 |  | 11 | 2009-07-01 00:00:00 | 2017-06-30 00:00:00
 |  | 12 | 2011-02-01 00:00:00 | 2020-01-31 00:00:00
 |  | 13 | 2016-08-01 00:00:00 | 2020-04-30 00:00:00
 |  | 14 | 2016-06-14 00:00:00 | 2019-01-31 00:00:00
 |  | 15 | 2013-02-01 00:00:00 | 2019-11-30 00:00:00
 |  | 16 | 2017-04-01 00:00:00 | 2019-03-31 00:00:00
 |  | 17 | 2018-01-18 00:00:00 | 2020-06-30 00:00:00
 |  | 18 | 2015-05-01 00:00:00 | 2020-04-30 00:00:00
 |  | 19 | 2014-03-01 00:00:00 | 2016-08-31 00:00:00
 |  | 20 | 2013-08-01 00:00:00 | 2020-02-29 00:00:00
 |  | 23 | 2011-06-01 00:00:00 | 2015-09-30 00:00:00
 |  | 24 | 2012-06-01 00:00:00 | 2012-08-31 00:00:00
 |  | 25 | 2013-06-01 00:00:00 | 2020-02-29 00:00:00
 |  | 27 | 2014-12-01 00:00:00 | 2015-11-30 00:00:00
 |  | 28 | 2013-09-09 00:00:00 | 2020-02-29 00:00:00
 |  | 29 | 2009-12-01 00:00:00 | 2011-01-31 00:00:00
 |  | 30 | 2013-08-01 00:00:00 | 2014-12-31 00:00:00
 |  | 31 | 2015-05-01 00:00:00 | 2020-04-30 00:00:00
 |  | 33 | 2016-07-01 00:00:00 | 2020-06-30 00:00:00
 |  | 34 | 2012-03-01 00:00:00 | 2017-07-31 00:00:00
 |  | 35 | 2015-10-01 00:00:00 | 2020-09-30 00:00:00
 |  | 36 | 2012-05-01 00:00:00 | 2020-04-30 00:00:00
 |  | 37 | 2014-04-30 00:00:00 | 2016-11-30 00:00:00
 |  | 38 | 2014-12-01 00:00:00 | 2015-11-30 00:00:00
 |  | 39 | 2018-09-01 00:00:00 | 2020-08-31 00:00:00
 |  | 40 | 2011-12-01 00:00:00 | 2012-11-30 00:00:00
 |  | 41 | 2014-09-01 00:00:00 | 2017-08-31 00:00:00
 |  | 42 | 2013-02-01 00:00:00 | 2013-03-31 00:00:00
 |  | 43 | 2016-01-01 00:00:00 | 2020-02-29 00:00:00
 |  | 44 | 2019-09-01 00:00:00 | 2019-11-30 00:00:00
 |  | 45 | 2018-04-01 00:00:00 | 2020-03-31 00:00:00
 |  | 46 | 2011-06-01 00:00:00 | 2014-11-30 00:00:00
 |  | 47 | 2009-12-01 00:00:00 | 2015-11-30 00:00:00
 |  | 48 | 2012-07-01 00:00:00 | 2020-02-29 00:00:00
 |  | 49 | 2017-06-01 00:00:00 | 2020-05-31 00:00:00
 |  | 50 | 2010-03-01 00:00:00 | 2014-05-31 00:00:00
 |  | 51 | 2012-02-01 00:00:00 | 2018-01-31 00:00:00
 |  | 52 | 2014-05-01 00:00:00 | 2020-02-29 00:00:00
 |  | 53 | 2010-11-01 00:00:00 | 2012-07-31 00:00:00
 |  | 54 | 2015-04-01 00:00:00 | 2020-03-31 00:00:00
 |  | 56 | 2012-04-01 00:00:00 | 2015-03-31 00:00:00
 |  | 57 | 2016-03-01 00:00:00 | 2020-02-29 00:00:00
 |  | 58 | 2012-07-01 00:00:00 | 2017-06-30 00:00:00
 |  | 59 | 2015-06-01 00:00:00 | 2018-08-31 00:00:00
 |  | 60 | 2015-06-08 00:00:00 | 2020-04-30 00:00:00
 |  | 61 | 2016-08-01 00:00:00 | 2020-07-31 00:00:00
 |  | 62 | 2013-01-01 00:00:00 | 2013-12-31 00:00:00
 |  | 63 | 2017-05-01 00:00:00 | 2020-04-30 00:00:00
 |  | 64 | 2010-02-01 00:00:00 | 2010-02-28 00:00:00
 |  | 66 | 2014-05-05 00:00:00 | 2018-11-30 00:00:00
 |  | 67 | 2012-02-01 00:00:00 | 2020-02-29 00:00:00
 |  | 68 | 2015-02-01 00:00:00 | 2020-02-29 00:00:00
 |  | 69 | 2011-07-01 00:00:00 | 2020-03-31 00:00:00
 |  | 70 | 2013-11-01 00:00:00 | 2015-01-31 00:00:00
 |  | 71 | 2013-04-01 00:00:00 | 2016-09-30 00:00:00
 |  | 72 | 2014-11-01 00:00:00 | 2020-10-31 00:00:00
 |  | 74 | 2010-09-01 00:00:00 | 2011-02-28 00:00:00
 |  | 75 | 2009-12-01 00:00:00 | 2010-10-31 00:00:00
 |  | 76 | 2011-05-01 00:00:00 | 2020-06-30 00:00:00
 |  | 77 | 2014-10-01 00:00:00 | 2020-09-30 00:00:00
 |  | 78 | 2015-11-01 00:00:00 | 2020-02-29 00:00:00
 |  | 79 | 2018-09-01 00:00:00 | 2020-02-29 00:00:00
 |  | 80 | 2011-12-12 00:00:00 | 2020-03-31 00:00:00
 |  | 82 | 2015-01-01 00:00:00 | 2020-02-29 00:00:00
 |  | 83 | 2013-12-01 00:00:00 | 2020-02-29 00:00:00
 |  | 84 | 2013-04-01 00:00:00 | 2013-06-30 00:00:00
 |  | 85 | 2012-01-01 00:00:00 | 2012-12-31 00:00:00
 |  | 86 | 2014-08-31 00:00:00 | 2015-08-31 00:00:00
 |  | 87 | 2013-12-01 00:00:00 | 2014-11-30 00:00:00
 |  | 88 | 2012-09-01 00:00:00 | 2020-02-29 00:00:00
 |  | 89 | 2012-10-01 00:00:00 | 2014-09-30 00:00:00
 |  | 90 | 2012-05-01 00:00:00 | 2014-04-30 00:00:00
 |  | 91 | 2009-04-01 00:00:00 | 2020-03-31 00:00:00
 |  | 92 | 2015-11-01 00:00:00 | 2020-10-31 00:00:00
 |  | 93 | 2013-06-01 00:00:00 | 2015-05-31 00:00:00
 |  | 94 | 2017-06-01 00:00:00 | 2020-02-29 00:00:00
 |  | 95 | 2016-02-01 00:00:00 | 2020-04-30 00:00:00
 |  | 96 | 2015-09-04 00:00:00 | 2018-12-31 00:00:00
 |  | 97 | 2011-06-01 00:00:00 | 2020-02-29 00:00:00
 |  | 98 | 2014-07-01 00:00:00 | 2014-09-30 00:00:00
 |  | 99 | 2011-11-01 00:00:00 | 2016-07-31 00:00:00
 |  | 100 | 2013-12-01 00:00:00 | 2014-08-31 00:00:00
 |  | 101 | 2013-11-01 00:00:00 | 2019-10-31 00:00:00
 |  | 102 | 2016-05-01 00:00:00 | 2019-11-30 00:00:00
 |  | 103 | 2018-10-01 00:00:00 | 2020-02-29 00:00:00
 |  | 104 | 2015-04-01 00:00:00 | 2020-03-31 00:00:00
 |  | 105 | 2009-09-01 00:00:00 | 2020-03-31 00:00:00
 |  | 106 | 2011-01-01 00:00:00 | 2020-04-30 00:00:00
 |  | 107 | 2013-12-01 00:00:00 | 2020-06-30 00:00:00
 |  | 108 | 2012-12-07 00:00:00 | 2020-12-31 00:00:00
 |  | 109 | 2011-11-01 00:00:00 | 2012-10-31 00:00:00
 |  | 110 | 2014-01-24 00:00:00 | 2015-12-31 00:00:00
 |  | 111 | 2012-08-09 00:00:00 | 2020-03-31 00:00:00
 |  | 114 | 2020-02-01 00:00:00 | 2020-02-29 00:00:00
 |  | 115 | 2015-07-01 00:00:00 | 2020-06-30 00:00:00
 |  | 116 | 2012-10-01 00:00:00 | 2020-03-31 00:00:00
 |  | 117 | 2015-07-01 00:00:00 | 2020-06-30 00:00:00
 |  | 120 | 2009-07-01 00:00:00 | 2013-06-30 00:00:00
 |  | 121 | 2009-10-01 00:00:00 | 2011-01-31 00:00:00
 |  | 122 | 2014-02-01 00:00:00 | 2020-04-30 00:00:00
 |  | 123 | 2017-06-01 00:00:00 | 2020-05-31 00:00:00
 |  | 125 | 2012-11-01 00:00:00 | 2015-10-31 00:00:00
 |  | 126 | 2013-04-01 00:00:00 | 2015-04-30 00:00:00
 |  | 127 | 2010-06-01 00:00:00 | 2013-05-31 00:00:00
 |  | 130 | 2016-10-11 00:00:00 | 2017-03-31 00:00:00
 |  | 131 | 2014-06-01 00:00:00 | 2020-05-31 00:00:00
 |  | 132 | 2010-04-01 00:00:00 | 2020-03-31 00:00:00
 |  | 133 | 2010-01-01 00:00:00 | 2018-07-31 00:00:00
 |  | 134 | 2016-12-01 00:00:00 | 2018-11-30 00:00:00
 |  | 137 | 2018-02-01 00:00:00 | 2020-07-31 00:00:00
 |  | 138 | 2016-10-03 00:00:00 | 2017-09-30 00:00:00
 |  | 139 | 2016-03-01 00:00:00 | 2020-02-29 00:00:00
 |  | 143 | 2017-11-15 00:00:00 | 2020-04-30 00:00:00
 |  | 144 | 2019-02-06 00:00:00 | 2020-02-29 00:00:00
 |  | 145 | 2016-09-01 00:00:00 | 2020-08-31 00:00:00
 |  | 146 | 2011-05-01 00:00:00 | 2020-04-30 00:00:00
 |  | 147 | 2011-01-01 00:00:00 | 2018-01-31 00:00:00
 |  | 148 | 2015-11-01 00:00:00 | 2020-08-31 00:00:00
 |  | 149 | 2013-08-01 00:00:00 | 2020-02-29 00:00:00
 |  | 150 | 2016-07-01 00:00:00 | 2019-06-30 00:00:00
 |  | 151 | 2011-11-01 00:00:00 | 2020-11-30 00:00:00
 |  | 152 | 2013-11-01 00:00:00 | 2020-10-31 00:00:00
 |  | 155 | 2009-10-01 00:00:00 | 2020-11-30 00:00:00
 |  | 157 | 2016-02-01 00:00:00 | 2019-01-31 00:00:00
 |  | 158 | 2013-09-01 00:00:00 | 2019-09-30 00:00:00
 |  | 159 | 2009-06-01 00:00:00 | 2020-12-31 00:00:00
 |  | 160 | 2013-04-01 00:00:00 | 2020-03-31 00:00:00
 |  | 161 | 2010-02-01 00:00:00 | 2020-04-30 00:00:00
 |  | 162 | 2015-02-02 00:00:00 | 2020-09-30 00:00:00
 |  | 163 | 2013-04-01 00:00:00 | 2014-03-31 00:00:00
 |  | 164 | 2011-07-01 00:00:00 | 2019-07-31 00:00:00
 |  | 165 | 2012-01-01 00:00:00 | 2020-02-29 00:00:00
 |  | 166 | 2017-03-01 00:00:00 | 2020-02-29 00:00:00
 |  | 168 | 2014-08-01 00:00:00 | 2019-03-31 00:00:00
 |  | 169 | 2009-09-01 00:00:00 | 2013-11-30 00:00:00
 |  | 170 | 2016-02-01 00:00:00 | 2021-01-31 00:00:00
 |  | 171 | 2010-07-01 00:00:00 | 2013-07-31 00:00:00
 |  | 173 | 2011-08-01 00:00:00 | 2018-02-28 00:00:00
 |  | 174 | 2018-07-01 00:00:00 | 2020-02-29 00:00:00
 |  | 176 | 2014-06-30 00:00:00 | 2015-06-30 00:00:00
 |  | 179 | 2012-05-01 00:00:00 | 2020-02-29 00:00:00
 |  | 180 | 2009-07-01 00:00:00 | 2015-03-31 00:00:00
 |  | 181 | 2013-02-01 00:00:00 | 2013-04-30 00:00:00
 |  | 182 | 2009-02-01 00:00:00 | 2020-02-29 00:00:00
 |  | 183 | 2012-05-01 00:00:00 | 2020-04-30 00:00:00
 |  | 184 | 2015-04-01 00:00:00 | 2020-02-29 00:00:00
 |  | 185 | 2013-02-01 00:00:00 | 2020-01-31 00:00:00
 |  | 187 | 2015-04-01 00:00:00 | 2020-03-31 00:00:00
 |  | 188 | 2011-06-16 00:00:00 | 2020-03-31 00:00:00
 |  | 189 | 2015-04-01 00:00:00 | 2020-02-29 00:00:00
 |  | 190 | 2009-06-08 00:00:00 | 2013-11-30 00:00:00
 |  | 191 | 2014-06-01 00:00:00 | 2017-01-31 00:00:00
 |  | 193 | 2019-06-17 00:00:00 | 2020-05-31 00:00:00
 |  | 194 | 2013-05-01 00:00:00 | 2014-04-30 00:00:00
 |  | 195 | 2011-03-16 00:00:00 | 2020-05-31 00:00:00
 |  | 196 | 2012-05-01 00:00:00 | 2016-12-31 00:00:00
 |  | 197 | 2017-04-01 00:00:00 | 2018-03-31 00:00:00
 |  | 198 | 2009-07-01 00:00:00 | 2019-05-31 00:00:00
 |  | 199 | 2014-01-01 00:00:00 | 2020-02-29 00:00:00
 |  | 200 | 2016-12-01 00:00:00 | 2018-11-30 00:00:00
 |  | 201 | 2012-08-01 00:00:00 | 2020-03-31 00:00:00
 |  | 203 | 2012-01-01 00:00:00 | 2020-03-31 00:00:00
 |  | 204 | 2019-11-01 00:00:00 | 2020-03-31 00:00:00
 |  | 205 | 2010-11-01 00:00:00 | 2020-04-30 00:00:00
 |  | 207 | 2014-04-01 00:00:00 | 2018-07-31 00:00:00
 |  | 208 | 2011-08-01 00:00:00 | 2020-07-31 00:00:00
 |  | 209 | 2009-11-01 00:00:00 | 2016-03-03 00:00:00
 |  | 210 | 2014-05-01 00:00:00 | 2020-05-31 00:00:00
 |  | 211 | 2013-01-01 00:00:00 | 2013-12-31 00:00:00
 |  | 212 | 2014-03-01 00:00:00 | 2015-02-28 00:00:00
 |  | 213 | 2012-05-01 00:00:00 | 2020-04-30 00:00:00
 |  | 214 | 2019-10-08 00:00:00 | 2019-12-31 00:00:00
 |  | 215 | 2016-08-16 00:00:00 | 2017-07-31 00:00:00
 |  | 216 | 2016-05-01 00:00:00 | 2020-04-30 00:00:00
 |  | 217 | 2018-09-15 00:00:00 | 2020-08-31 00:00:00
 |  | 218 | 2011-01-01 00:00:00 | 2011-05-31 00:00:00
 |  | 219 | 2018-02-01 00:00:00 | 2020-02-29 00:00:00
 |  | 221 | 2015-07-01 00:00:00 | 2016-03-31 00:00:00
 |  | 223 | 2015-03-01 00:00:00 | 2020-05-31 00:00:00
 |  | 224 | 2013-12-01 00:00:00 | 2020-03-31 00:00:00
 |  | 225 | 2010-04-01 00:00:00 | 2017-04-30 00:00:00
 |  | 226 | 2019-04-01 00:00:00 | 2020-03-31 00:00:00
 |  | 227 | 2009-07-01 00:00:00 | 2020-06-30 00:00:00
 |  | 228 | 2010-05-01 00:00:00 | 2018-01-31 00:00:00
 |  | 229 | 2017-07-01 00:00:00 | 2019-06-30 00:00:00
 |  | 230 | 2009-10-13 00:00:00 | 2018-08-31 00:00:00
 |  | 231 | 2018-11-01 00:00:00 | 2020-10-31 00:00:00
 |  | 232 | 2014-08-01 00:00:00 | 2020-04-30 00:00:00
 |  | 233 | 2017-12-01 00:00:00 | 2018-12-31 00:00:00
 |  | 234 | 2013-04-01 00:00:00 | 2019-03-31 00:00:00
 |  | 235 | 2012-06-01 00:00:00 | 2020-05-31 00:00:00
 |  | 236 | 2013-04-01 00:00:00 | 2020-03-31 00:00:00
 |  | 237 | 2011-12-01 00:00:00 | 2017-06-30 00:00:00
 |  | 238 | 2016-03-01 00:00:00 | 2018-04-30 00:00:00
 |  | 239 | 2009-12-01 00:00:00 | 2013-12-31 00:00:00
 |  | 240 | 2009-04-01 00:00:00 | 2020-03-31 00:00:00
 |  | 241 | 2016-06-01 00:00:00 | 2020-02-29 00:00:00
 |  | 242 | 2014-09-01 00:00:00 | 2018-08-31 00:00:00
 |  | 243 | 2012-11-01 00:00:00 | 2020-12-31 00:00:00
 |  | 244 | 2010-03-01 00:00:00 | 2020-02-29 00:00:00
 |  | 245 | 2014-01-01 00:00:00 | 2020-04-30 00:00:00
 |  |  |  | New
 |  |  |  | Lost
 |  |  |  | End