Spreadsheet: 80290d1280459349-excel-2007-finding-dates-book1
Sheet: Sheet1

Policy number | Anticipated Exit Date | 2008-12-01 00:00:00 | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00 | 2009-06-01 00:00:00 | 2009-07-01 00:00:00 | 2009-08-01 00:00:00 | 2009-09-01 00:00:00 | 2009-10-01 00:00:00 | 2009-11-01 00:00:00 | 2009-12-01 00:00:00 | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | Date Done | Date done [NAME] | 6 months | 12 months | Reported in same month | Reported 1 month prior | Reported month | Reported when Date Done | 6mth Re | 12mth Re
1 | 2009-04-19 00:00:00 | 2008-12-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-31 00:00:00 | 2009-10-31 00:00:00 | 2009-07-31 00:00:00 | 2010-01-31 00:00:00 |  | 2008-12-31 00:00:00 | 2008-12-31 00:00:00 | Yes
2 | 2009-01-09 00:00:00 | 2008-12-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-31 00:00:00 | 2009-07-31 00:00:00 | 2009-07-31 00:00:00 | 2010-01-31 00:00:00 |  | 2008-12-31 00:00:00 | 2008-12-31 00:00:00 | Yes
3 | 2009-04-19 00:00:00 |  | 2009-01-31 00:00:00 |  |  |  | 2009-05-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-31 00:00:00 | 2009-10-31 00:00:00 | 2009-07-31 00:00:00 | 2010-01-31 00:00:00 | 2009-01-31 00:00:00 |  | 2009-01-31 00:00:00 | Yes
4 | 2009-07-19 00:00:00 |  | 2009-01-31 00:00:00 | 2009-02-28 00:00:00 | 2009-03-31 00:00:00 |  |  |  |  |  |  |  |  |  | 2010-01-31 00:00:00 | 2010-02-28 00:00:00 | 2010-03-31 00:00:00 |  | 2010-05-31 00:00:00 | 2009-01-31 00:00:00 | 2010-01-31 00:00:00 | 2009-07-31 00:00:00 | 2010-01-31 00:00:00 | 2009-01-31 00:00:00 |  | 2009-01-31 00:00:00 | Yes |  | 2010-01-31 00:00:00
5 | 2009-04-15 00:00:00 |  | 2009-01-31 00:00:00 | 2009-02-28 00:00:00 |  |  | 2009-05-31 00:00:00 | 2009-06-30 00:00:00 |  | 2009-08-31 00:00:00 | 2009-09-30 00:00:00 |  |  |  |  |  |  |  |  | 2009-01-31 00:00:00 | 2009-10-31 00:00:00 | 2009-07-31 00:00:00 | 2010-01-31 00:00:00 | 2009-01-31 00:00:00 |  | 2009-01-31 00:00:00 | Yes
6 | 2009-04-21 00:00:00 |  | 2009-01-31 00:00:00 | 2009-02-28 00:00:00 | 2009-03-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-31 00:00:00 | 2009-10-31 00:00:00 | 2009-07-31 00:00:00 | 2010-01-31 00:00:00 | 2009-01-31 00:00:00 |  | 2009-01-31 00:00:00 | Yes
7 | 2009-06-22 00:00:00 | 2008-12-31 00:00:00 | 2009-01-31 00:00:00 | 2009-02-28 00:00:00 | 2009-03-31 00:00:00 | 2009-04-30 00:00:00 | 2009-05-31 00:00:00 | 2009-06-30 00:00:00 | 2009-07-31 00:00:00 | 2009-08-31 00:00:00 |  |  |  |  |  |  |  |  |  | 2009-03-31 00:00:00 | 2009-12-31 00:00:00 | 2009-09-30 00:00:00 | 2010-03-31 00:00:00 | 2009-03-31 00:00:00 | 2009-02-28 00:00:00 | 2009-03-31 00:00:00 | Yes
8 | 2009-04-22 00:00:00 | 2008-12-31 00:00:00 | 2009-01-31 00:00:00 |  |  |  | 2009-05-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-31 00:00:00 | 2009-10-31 00:00:00 | 2009-07-31 00:00:00 | 2010-01-31 00:00:00 | 2009-01-31 00:00:00 | 2008-12-31 00:00:00 | 2009-01-31 00:00:00 | Yes
9 | 2009-05-11 00:00:00 |  |  | 2009-02-28 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-02-28 00:00:00 | 2009-11-30 00:00:00 | 2009-08-28 00:00:00 | 2010-02-28 00:00:00 | 2009-02-28 00:00:00 |  | 2009-02-28 00:00:00 | Yes
10 | 2009-04-22 00:00:00 | 2008-12-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-31 00:00:00 | 2009-10-31 00:00:00 | 2009-07-31 00:00:00 | 2010-01-31 00:00:00 |  | 2008-12-31 00:00:00 | 2008-12-31 00:00:00 | Yes
11 | 2009-07-21 00:00:00 | 2008-12-31 00:00:00 | 2009-01-31 00:00:00 | 2009-02-28 00:00:00 | 2009-03-31 00:00:00 |  |  |  | 2009-07-31 00:00:00 | 2009-08-31 00:00:00 | 2009-09-30 00:00:00 | 2009-10-31 00:00:00 | 2009-11-30 00:00:00 | 2009-12-31 00:00:00 | 2010-01-31 00:00:00 | 2010-02-28 00:00:00 | 2010-03-31 00:00:00 | 2010-04-30 00:00:00 |  | 2009-01-31 00:00:00 | 2010-01-31 00:00:00 | 2009-07-31 00:00:00 | 2010-01-31 00:00:00 | 2009-01-31 00:00:00 | 2008-12-31 00:00:00 | 2009-01-31 00:00:00 | Yes | 2009-07-31 00:00:00 | 2010-01-31 00:00:00
12 | 2009-07-26 00:00:00 |  | 2009-01-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-31 00:00:00 | 2010-01-31 00:00:00 | 2009-07-31 00:00:00 | 2010-01-31 00:00:00 | 2009-01-31 00:00:00 |  | 2009-01-31 00:00:00 | Yes
13 | 2009-04-28 00:00:00 | 2008-12-31 00:00:00 | 2009-01-31 00:00:00 |  | 2009-03-31 00:00:00 | 2009-04-30 00:00:00 | 2009-05-31 00:00:00 | 2009-06-30 00:00:00 |  |  |  |  |  | 2009-12-31 00:00:00 | 2010-01-31 00:00:00 | 2010-02-28 00:00:00 | 2010-03-31 00:00:00 | 2010-04-30 00:00:00 | 2010-05-31 00:00:00 | 2009-01-31 00:00:00 | 2009-10-31 00:00:00 | 2009-07-31 00:00:00 | 2010-01-31 00:00:00 | 2009-01-31 00:00:00 | 2008-12-31 00:00:00 | 2009-01-31 00:00:00 | Yes |  | 2010-01-31 00:00:00
14 | 2009-04-28 00:00:00 | 2008-12-31 00:00:00 | 2009-01-31 00:00:00 | 2009-02-28 00:00:00 | 2009-03-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-31 00:00:00 | 2009-10-31 00:00:00 | 2009-07-31 00:00:00 | 2010-01-31 00:00:00 | 2009-01-31 00:00:00 | 2008-12-31 00:00:00 | 2009-01-31 00:00:00 | Yes
15 | 2009-02-27 00:00:00 | 2008-12-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-31 00:00:00 | 2009-08-31 00:00:00 | 2009-07-31 00:00:00 | 2010-01-31 00:00:00 |  | 2008-12-31 00:00:00 | 2008-12-31 00:00:00 | Yes
16 | 2009-01-29 00:00:00 |  | 2009-01-31 00:00:00 | 2009-02-28 00:00:00 | 2009-03-31 00:00:00 | 2009-04-30 00:00:00 | 2009-05-31 00:00:00 |  | 2009-07-31 00:00:00 | 2009-08-31 00:00:00 |  |  | 2009-11-30 00:00:00 |  | 2010-01-31 00:00:00 | 2010-02-28 00:00:00 | 2010-03-31 00:00:00 | 2010-04-30 00:00:00 | 2010-05-31 00:00:00 | 2009-01-31 00:00:00 | 2009-07-31 00:00:00 | 2009-07-31 00:00:00 | 2010-01-31 00:00:00 | 2009-01-31 00:00:00 |  | 2009-01-31 00:00:00 | Yes | 2009-07-31 00:00:00 | 2010-01-31 00:00:00
17 | 2009-04-29 00:00:00 | 2008-12-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 2010-01-31 00:00:00 | 2010-02-28 00:00:00 | 2010-03-31 00:00:00 | 2010-04-30 00:00:00 | 2010-05-31 00:00:00 | 2009-01-31 00:00:00 | 2009-10-31 00:00:00 | 2009-07-31 00:00:00 | 2010-01-31 00:00:00 |  | 2008-12-31 00:00:00 | 2008-12-31 00:00:00 | Yes |  | 2010-01-31 00:00:00
18 | 2009-12-01 00:00:00 | 2008-12-31 00:00:00 | 2009-01-31 00:00:00 | 2009-02-28 00:00:00 | 2009-03-31 00:00:00 | 2009-04-30 00:00:00 | 2009-05-31 00:00:00 | 2009-06-30 00:00:00 | 2009-07-31 00:00:00 | 2009-08-31 00:00:00 |  |  |  |  |  |  |  |  |  | 2009-02-28 00:00:00 | 2010-06-30 00:00:00 | 2009-08-28 00:00:00 | 2010-02-28 00:00:00 | 2009-02-28 00:00:00 |  | 2009-02-28 00:00:00 | Yes
19 | 2009-04-06 00:00:00 |  | 2009-01-31 00:00:00 | 2009-02-28 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-02-28 00:00:00 | 2009-10-31 00:00:00 | 2009-08-28 00:00:00 | 2010-02-28 00:00:00 | 2009-02-28 00:00:00 |  | 2009-02-28 00:00:00 | Yes
20 | 2009-02-09 00:00:00 |  |  | 2009-02-28 00:00:00 | 2009-03-31 00:00:00 | 2009-04-30 00:00:00 | 2009-05-31 00:00:00 | 2009-06-30 00:00:00 | 2009-07-31 00:00:00 | 2009-08-31 00:00:00 | 2009-09-30 00:00:00 | 2009-10-31 00:00:00 | 2009-11-30 00:00:00 | 2009-12-31 00:00:00 | 2010-01-31 00:00:00 | 2010-02-28 00:00:00 | 2010-03-31 00:00:00 | 2010-04-30 00:00:00 |  | 2009-02-28 00:00:00 | 2009-08-31 00:00:00 | 2009-08-28 00:00:00 | 2010-02-28 00:00:00 | 2009-02-28 00:00:00 |  | 2009-02-28 00:00:00 | Yes |  | 2010-02-28 00:00:00
21 | 2009-05-07 00:00:00 |  |  | 2009-02-28 00:00:00 |  |  | 2009-05-31 00:00:00 |  |  |  |  | 2009-10-31 00:00:00 | 2009-11-30 00:00:00 |  |  | 2010-02-28 00:00:00 | 2010-03-31 00:00:00 | 2010-04-30 00:00:00 | 2010-05-31 00:00:00 | 2009-02-28 00:00:00 | 2009-11-30 00:00:00 | 2009-08-28 00:00:00 | 2010-02-28 00:00:00 | 2009-02-28 00:00:00 |  | 2009-02-28 00:00:00 | Yes |  | 2010-02-28 00:00:00
22 | 2009-08-08 00:00:00 |  | 2009-01-31 00:00:00 | 2009-02-28 00:00:00 | 2009-03-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-02-28 00:00:00 | 2010-02-28 00:00:00 | 2009-08-28 00:00:00 | 2010-02-28 00:00:00 | 2009-02-28 00:00:00 |  | 2009-02-28 00:00:00 | Yes
23 | 2009-11-22 00:00:00 |  |  | 2009-02-28 00:00:00 | 2009-03-31 00:00:00 | 2009-04-30 00:00:00 | 2009-05-31 00:00:00 | 2009-06-30 00:00:00 | 2009-07-31 00:00:00 | 2009-08-31 00:00:00 | 2009-09-30 00:00:00 | 2009-10-31 00:00:00 | 2009-11-30 00:00:00 | 2009-12-31 00:00:00 | 2010-01-31 00:00:00 | 2010-02-28 00:00:00 |  |  |  | 2009-05-31 00:00:00 | 2010-05-31 00:00:00 | 2009-11-30 00:00:00 | 2010-05-31 00:00:00 | 2009-05-31 00:00:00 | 2009-04-30 00:00:00 | 2009-05-31 00:00:00 | Yes | 2009-11-30 00:00:00