Spreadsheet: 238244d1369426524-working-with-previous-dates-in-excel-book3
Sheet: Sheet1

Report's Date | 2013-05-23 00:00:00
Lead Number | Assignee | [NAME] | Client | Age | New Status | Active Lead | Active Client | Cancelled Lead | Cancelled Client | Last Enroll Date | Prev. to Last Enroll Date |  |  |  |  | [NAME] | New Status
 |  |  |  |  |  |  |  |  |  |  |  | should be 4/25
13611826 | [NAME] | Retainer Sent | [NAME] | 1 Hour | Active Lead |  |  |  |  |  |  |  |  |  |  | Fair Debt Lead | Active Lead
13611780 | [NAME] | Retainer Sent | Beatriz Contreras | 2 Hours | Active Lead |  |  |  |  |  |  |  |  |  |  | Retainer Sent | Active Lead
13196196 | [NAME] | Retainer Sent | [NAME] | 38 Days | Active Lead |  |  |  |  |  |  |  |  |  |  | Retainer Received | Active Client
13562672 | [NAME] | Retainer Received | [NAME] | 2 Hours | Active Client |  |  |  |  |  |  |  |  |  |  | Pre-Complaint | Active Client
13742394 | [NAME] | Retainer Received | [NAME] | 4 Hours | Active Client |  |  |  |  |  |  |  |  |  |  | Ready For Complaint | Active Client
13415707 | [NAME] | Retainer Received | [NAME] | 29 Days | Active Client |  |  |  |  |  |  |  |  |  |  | Complaint Drafted | Active Client
13196351 | [NAME] | Retainer Received | [NAME] | 29 Days | Active Client |  |  |  |  |  |  |  |  |  |  | Send Settlement Letter | Active Client
12917812 | [NAME] | Retainer Received | [NAME] | 34 Days | Active Client |  |  |  |  |  |  |  |  |  |  | RSTL? | Active Client
13366547 | [NAME] | Retainer Received | [NAME] | 42 Days | Active Client |  |  |  |  |  |  |  |  |  |  | File Complaint | Active Client
13366545 | [NAME] | Retainer Received | [NAME] | 48 Days | Active Client |  |  |  |  |  |  |  |  |  |  | Settled Case | Cases Settled
12854800 | [NAME] | Retainer Received | [NAME] | 49 Days | Active Client |  |  |  |  |  |  |  |  |  |  | $ Here | Active Client
13103159 | [NAME] | Retainer Received | [NAME] | 56 Days | Active Client |  |  |  |  |  |  |  |  |  |  | $ [NAME] | Active Client
13015186 | [NAME] | Retainer Received | [NAME] | 59 Days | Active Client |  |  |  |  |  |  |  |  |  |  | FDL ==> COF | Cancelled Lead
13180346 | [NAME] | Retainer Received | [NAME] | 73 Days | Active Client |  |  |  |  |  |  |  |  |  |  | RET ==> COF | Cancelled Client
12678751 | [NAME] | Retainer Received | [NAME] | 77 Days | Active Client |  |  |  |  |  |  |  |  |  |  | REC ==> COF | Cancelled Client
12679838 | [NAME] | Retainer Received | [NAME] | 78 Days | Active Client |  |  |  |  |  |  |  |  |  |  | SET ==> COF | Cancelled Client
13187491 | [NAME] | Pre-Complaint | [NAME] | 30 Days | Active Client |  |  |  |  |  |  |  |  |  |  | $ Here ==> COF | Cancelled Client
12736724 | [NAME] | FDL ==> COF | [NAME] | < 1 Hour | Cancelled Lead |  |  |  |  |  |  |  |  |  |  | Checks Written == > COF | Cancelled Client
13287793 | [NAME] | FDL ==> COF | [NAME] | 1 Day | Cancelled Lead |  |  |  |  |  |  |  |  |  |  | **Trash Test Leads ** | REMOVE
13509671 | [NAME] | FDL ==> COF | [NAME] | 8 Days | Cancelled Lead
13459278 | [NAME] | FDL ==> COF | [NAME] | 29 Days | Cancelled Lead
13509691 | [NAME] | FDL ==> COF | [NAME] | 29 Days | Cancelled Lead
13196191 | [NAME] | FDL ==> COF | [NAME] | 34 Days | Cancelled Lead
13509620 | [NAME] | FDL ==> COF | [NAME] | 38 Days | Cancelled Lead
13459277 | [NAME] | FDL ==> COF | [NAME] | 38 Days | Cancelled Lead
13196350 | [NAME] | FDL ==> COF | [NAME] | 42 Days | Cancelled Lead
13077134 | [NAME] | FDL ==> COF | [NAME] | 59 Days | Cancelled Lead
13015188 | [NAME] | FDL ==> COF | Mozell Hawkins | 70 Days | Cancelled Lead
12854797 | [NAME] | FDL ==> COF | [NAME] | 76 Days | Cancelled Lead
13077116 | [NAME] | FDL ==> COF | [NAME] | 76 Days | Cancelled Lead
13015189 | [NAME] | FDL ==> COF | Thuan Tran | 76 Days | Cancelled Lead
13015187 | [NAME] | FDL ==> COF | [NAME] | 76 Days | Cancelled Lead
12678752 | [NAME] | FDL ==> COF | [NAME] | 79 Days | Cancelled Lead
13015183 | [NAME] | FDL ==> COF | [NAME] | 80 Days | Cancelled Lead
12679834 | [NAME] | FDL ==> COF | Tiffany Ziegler | 80 Days | Cancelled Lead
12128543 | [NAME] | FDL ==> COF | [NAME] | 98 Days | Cancelled Lead
12128542 | [NAME] | RET ==> COF | [NAME] | 7 Days | Cancelled Client