Spreadsheet: 88569d1288359948-365-day-countdown-between-two-dates-anniversary-dates
Sheet: Sheet1

2010-11-17 00:00:00
Client Database
Client Name | Status | Start Date | Anniversary date | DD/MM/YY since Start Date | Days to Anniv
 | Ring Client | 2009-11-17 00:00:00 | 2010-11-17 00:00:00 | 0 days, 0 months, 1 years | 0
 | Within 7 days | 2009-11-20 00:00:00 | 2010-11-20 00:00:00 | 27 days, 11 months, 0 years | 3
 | Pending | 2009-11-26 00:00:00 | 2010-11-26 00:00:00 | 21 days, 11 months, 0 years | 9
 | Pending | 2009-12-01 00:00:00 | 2010-12-01 00:00:00 | 16 days, 11 months, 0 years | 14
 | Pending | 2009-12-09 00:00:00 | 2010-12-09 00:00:00 | 8 days, 11 months, 0 years | 22
 | Pending | 2007-12-11 00:00:00 | 2010-12-11 00:00:00 | 6 days, 11 months, 2 years | 24
 | Pending | 2009-12-17 00:00:00 | 2010-12-17 00:00:00 | 0 days, 11 months, 0 years | 30
 | Pending | 2008-01-01 00:00:00 | 2011-01-01 00:00:00 | 16 days, 10 months, 2 years | 45
 | Pending | 2010-01-21 00:00:00 | 2011-01-21 00:00:00 | 26 days, 9 months, 0 years | 65
 | Pending | 2008-01-22 00:00:00 | 2011-01-22 00:00:00 | 25 days, 9 months, 2 years | 66
 | Pending | 2008-01-23 00:00:00 | 2011-01-23 00:00:00 | 24 days, 9 months, 2 years | 67
 | Pending | 2008-01-24 00:00:00 | 2011-01-24 00:00:00 | 23 days, 9 months, 2 years | 68
 | Pending | 2008-01-25 00:00:00 | 2011-01-25 00:00:00 | 22 days, 9 months, 2 years | 69
 | Pending | 2010-02-11 00:00:00 | 2011-02-11 00:00:00 | 6 days, 9 months, 0 years | 86
 | Pending | 2008-02-12 00:00:00 | 2011-02-12 00:00:00 | 5 days, 9 months, 2 years | 87
 | Pending | 2010-02-12 00:00:00 | 2011-02-12 00:00:00 | 5 days, 9 months, 0 years | 87
 | Pending | 2009-02-19 00:00:00 | 2011-02-19 00:00:00 | 28 days, 8 months, 1 years | 94
 | Pending | 2008-02-25 00:00:00 | 2011-02-25 00:00:00 | 22 days, 8 months, 2 years | 100
 | Pending | 2007-02-28 00:00:00 | 2011-02-28 00:00:00 | 19 days, 8 months, 3 years | 103
 | Pending | 2007-03-01 00:00:00 | 2011-03-01 00:00:00 | 16 days, 8 months, 3 years | 104
 | Pending | 2008-03-03 00:00:00 | 2011-03-03 00:00:00 | 14 days, 8 months, 2 years | 106
 | Pending | 2007-03-09 00:00:00 | 2011-03-09 00:00:00 | 8 days, 8 months, 3 years | 112
 | Pending | 2008-03-13 00:00:00 | 2011-03-13 00:00:00 | 4 days, 8 months, 2 years | 116
 | Pending | 2009-03-19 00:00:00 | 2011-03-19 00:00:00 | 28 days, 7 months, 1 years | 122
 | Pending | 2010-03-22 00:00:00 | 2011-03-22 00:00:00 | 25 days, 7 months, 0 years | 125
 | Pending | 2009-03-23 00:00:00 | 2011-03-23 00:00:00 | 24 days, 7 months, 1 years | 126
 | Pending | 2010-03-25 00:00:00 | 2011-03-25 00:00:00 | 22 days, 7 months, 0 years | 128
 | Pending | 2010-03-25 00:00:00 | 2011-03-25 00:00:00 | 22 days, 7 months, 0 years | 128
 | Pending | 2008-03-25 00:00:00 | 2011-03-25 00:00:00 | 22 days, 7 months, 2 years | 128
 | Pending | 2008-03-26 00:00:00 | 2011-03-26 00:00:00 | 21 days, 7 months, 2 years | 129
 | Pending | 2010-03-29 00:00:00 | 2011-03-29 00:00:00 | 18 days, 7 months, 0 years | 132
 | Pending | 2007-03-29 00:00:00 | 2011-03-29 00:00:00 | 18 days, 7 months, 3 years | 132
 | Pending | 2010-03-30 00:00:00 | 2011-03-30 00:00:00 | 17 days, 7 months, 0 years | 133
 | Pending | 2010-04-01 00:00:00 | 2011-04-01 00:00:00 | 16 days, 7 months, 0 years | 135
 | Pending | 2009-04-01 00:00:00 | 2011-04-01 00:00:00 | 16 days, 7 months, 1 years | 135
 | Pending | 2007-04-05 00:00:00 | 2011-04-05 00:00:00 | 12 days, 7 months, 3 years | 139
 | Pending | 2010-04-06 00:00:00 | 2011-04-06 00:00:00 | 11 days, 7 months, 0 years | 140
 | Pending | 2008-04-07 00:00:00 | 2011-04-07 00:00:00 | 10 days, 7 months, 2 years | 141
 | Pending | 2008-04-07 00:00:00 | 2011-04-07 00:00:00 | 10 days, 7 months, 2 years | 141
 | Pending | 2008-04-07 00:00:00 | 2011-04-07 00:00:00 | 10 days, 7 months, 2 years | 141
 | Pending | 2009-04-09 00:00:00 | 2011-04-09 00:00:00 | 8 days, 7 months, 1 years | 143
 | Pending | 2007-04-17 00:00:00 | 2011-04-17 00:00:00 | 0 days, 7 months, 3 years | 151
 | Pending | 2007-04-19 00:00:00 | 2011-04-19 00:00:00 | 28 days, 6 months, 3 years | 153
 | Pending | 2008-04-19 00:00:00 | 2011-04-19 00:00:00 | 28 days, 6 months, 2 years | 153
 | Pending | 2009-04-21 00:00:00 | 2011-04-21 00:00:00 | 26 days, 6 months, 1 years | 155
 | Pending | 2009-04-24 00:00:00 | 2011-04-24 00:00:00 | 23 days, 6 months, 1 years | 158
 | Pending | 2009-05-03 00:00:00 | 2011-05-03 00:00:00 | 14 days, 6 months, 1 years | 167
 | Pending | 2010-05-06 00:00:00 | 2011-05-06 00:00:00 | 11 days, 6 months, 0 years | 170
 | Pending | 2007-05-11 00:00:00 | 2011-05-11 00:00:00 | 6 days, 6 months, 3 years | 175
 | Pending | 2009-05-13 00:00:00 | 2011-05-13 00:00:00 | 4 days, 6 months, 1 years | 177
 | Pending | 2007-05-17 00:00:00 | 2011-05-17 00:00:00 | 0 days, 6 months, 3 years | 181
 | Pending | 2007-05-17 00:00:00 | 2011-05-17 00:00:00 | 0 days, 6 months, 3 years | 181
 | Pending | 2010-05-19 00:00:00 | 2011-05-19 00:00:00 | 28 days, 5 months, 0 years | 183
 | Pending | 2010-05-27 00:00:00 | 2011-05-27 00:00:00 | 20 days, 5 months, 0 years | 191
 | Pending | 2007-05-31 00:00:00 | 2011-05-31 00:00:00 | 16 days, 5 months, 3 years | 195
 | Pending | 2010-06-10 00:00:00 | 2011-06-10 00:00:00 | 7 days, 5 months, 0 years | 205
 | Pending | 2008-06-17 00:00:00 | 2011-06-17 00:00:00 | 0 days, 5 months, 2 years | 212
 | Pending | 2008-06-17 00:00:00 | 2011-06-17 00:00:00 | 0 days, 5 months, 2 years | 212
 | Pending | 2007-06-29 00:00:00 | 2011-06-29 00:00:00 | 18 days, 4 months, 3 years | 224
 | Pending | 2008-06-30 00:00:00 | 2011-06-30 00:00:00 | 17 days, 4 months, 2 years | 225
 | Pending | 2008-07-01 00:00:00 | 2011-07-01 00:00:00 | 16 days, 4 months, 2 years | 226
 | Pending | 2008-07-10 00:00:00 | 2011-07-10 00:00:00 | 7 days, 4 months, 2 years | 235
 | Pending | 2008-07-11 00:00:00 | 2011-07-11 00:00:00 | 6 days, 4 months, 2 years | 236
 | Pending | 2008-07-11 00:00:00 | 2011-07-11 00:00:00 | 6 days, 4 months, 2 years | 236
 | Pending | 2009-07-13 00:00:00 | 2011-07-13 00:00:00 | 4 days, 4 months, 1 years | 238
 | Pending | 2009-07-13 00:00:00 | 2011-07-13 00:00:00 | 4 days, 4 months, 1 years | 238
 | Pending | 2009-07-13 00:00:00 | 2011-07-13 00:00:00 | 4 days, 4 months, 1 years | 238
 | Pending | 2009-07-13 00:00:00 | 2011-07-13 00:00:00 | 4 days, 4 months, 1 years | 238
 | Pending | 2010-07-28 00:00:00 | 2011-07-28 00:00:00 | 19 days, 3 months, 0 years | 253
 | Pending | 2010-08-04 00:00:00 | 2011-08-04 00:00:00 | 13 days, 3 months, 0 years | 260
 | Pending | 2010-08-10 00:00:00 | 2011-08-10 00:00:00 | 7 days, 3 months, 0 years | 266
 | Pending | 2010-08-12 00:00:00 | 2011-08-12 00:00:00 | 5 days, 3 months, 0 years | 268
 | Pending | 2009-08-15 00:00:00 | 2011-08-15 00:00:00 | 2 days, 3 months, 1 years | 271
 | Pending | 2010-08-17 00:00:00 | 2011-08-17 00:00:00 | 0 days, 3 months, 0 years | 273
 | Pending | 2008-08-20 00:00:00 | 2011-08-20 00:00:00 | 27 days, 2 months, 2 years | 276
 | Pending | 2010-09-21 00:00:00 | 2011-09-21 00:00:00 | 26 days, 1 months, 0 years | 308
 | Pending | 2008-09-30 00:00:00 | 2011-09-30 00:00:00 | 17 days, 1 months, 2 years | 317
 | Pending | 2008-10-03 00:00:00 | 2011-10-03 00:00:00 | 14 days, 1 months, 2 years | 320
 | Pending | 2009-10-27 00:00:00 | 2011-10-27 00:00:00 | 20 days, 0 months, 1 years | 344
 | Pending | 2009-11-06 00:00:00 | 2011-11-06 00:00:00 | 11 days, 0 months, 1 years | 354