Spreadsheet: 271327d1381913724-how-to-sum-cells-based-off-of-a-date-range-new-test-file-2
Sheet: May 2013

 | Re | Last | First |  |  |  | LOC |  | LOC | LOS |  | Discharge | Geograhpy | Method of
MR# | Admit | Name | Name | Age | Sex | DOA | (Admissions) | DOD | (Discharge) | (#of days) | TOD | To |  | Payment | LOS
 | 1 |  | [NAME] | 46 | M | 2013-05-01 00:00:00 | [NAME] | 2013-06-05 00:00:00 | IOP | 36 | Complete |  | OH | INS
 | 1 |  | [NAME] | 23 | F | 2013-05-01 00:00:00 | [NAME] | 2013-05-07 00:00:00 | [NAME] | 7 | Complete |  | WA | INS
 | 1 |  | Nathan | 23 | M | 2013-05-01 00:00:00 | [NAME] | 2013-07-03 00:00:00 | IOP | 64 | Clinical |  | FL | INS
 | 1 |  | [NAME] | 29 | M | 2013-05-01 00:00:00 | [NAME] | 2013-06-04 00:00:00 | IOP | 35 | AMA |  | TN | CASH
 | 1 |  | [NAME] | 18 | M | 2013-05-02 00:00:00 | [NAME] | 2013-05-03 00:00:00 | [NAME] | 2 | Complete |  | CT | INS
 | 1 |  | Carole | 53 | F | 2013-05-02 00:00:00 | [NAME] | 2013-06-08 00:00:00 | IOP | 38 | Complete |  | FL | INS
 | 1 |  | [NAME] | 30 | M | 2013-05-02 00:00:00 | [NAME] | 2013-05-07 00:00:00 | [NAME] | 6 | Complete |  | FL | CASH
 | 1 |  | [NAME] | 19 | M | 2013-05-03 00:00:00 | [NAME] | 2013-06-03 00:00:00 | PHP | 35 | Complete |  | OH | INS
 | 1 |  | [NAME] | 28 | M | 2013-05-03 00:00:00 | [NAME] | 2013-06-08 00:00:00 | IOP | 37 | Complete |  | PA | INS
 | 1 |  | Chase | 20 | M | 2013-05-03 00:00:00 | [NAME] | 2013-05-03 00:00:00 | [NAME] | 1 |  |  | IL | INS
 | 1 |  | Dustin | 23 | M | 2013-05-03 00:00:00 | [NAME] | 2013-06-08 00:00:00 | IOP | 37 | Complete |  | MO | INS
 | 1 |  | Tyler | 22 | M | 2013-05-03 00:00:00 | [NAME] | 2013-05-11 00:00:00 | IOP | 9 | AMA |  | NJ | INS
 | 1 |  | [NAME] | 47 | M | 2013-05-03 00:00:00 | [NAME] | 2013-05-07 00:00:00 | [NAME] | 5 | Complete |  | FL | INS
 | 2 |  | [NAME] | 21 | F | 2013-05-03 00:00:00 | [NAME] | 2013-05-07 00:00:00 | [NAME] | 5 | Complete |  | MA | INS
 | 2 |  | [NAME] | 21 | F | 2013-05-03 00:00:00 | [NAME] | 2013-05-06 00:00:00 | [NAME] | 4 | Complete |  | NY | INS
 | 1 |  | [NAME] | 24 | M | 2013-05-03 00:00:00 | [NAME] | 2013-05-10 00:00:00 | [NAME] | 8 | Complete |  | NY | INS
 | 1 |  | [NAME] | 21 | M | 2013-05-03 00:00:00 | [NAME] | 2013-05-16 00:00:00 | PHP | 14 | Complete |  | RI | INS
 | 1 |  | Justin | 24 | M | 2013-05-04 00:00:00 | [NAME] | 2013-05-09 00:00:00 | [NAME] | 6 | Complete |  | NC | INS
 | 4 |  | [NAME] | 22 | F | 2013-05-04 00:00:00 | [NAME] | 2013-05-10 00:00:00 | [NAME] | 7 | Complete |  | MI | INS
 | 1 |  | [NAME] | 51 | M | 2013-05-04 00:00:00 | [NAME] | 2013-05-07 00:00:00 | [NAME] | 4 | Complete |  | NJ | INS
 | 1 |  | [NAME] | 24 | F | 2013-05-04 00:00:00 | [NAME] | 2013-06-15 00:00:00 | IOP | 43 | Complete |  | FL | INS
 | 1 |  | Zachary | 26 | M | 2013-05-04 00:00:00 | [NAME] | 2013-05-23 00:00:00 | IOP | 20 | Complete |  |  | INS
 | 2 |  | [NAME] | 23 | M | 2013-05-04 00:00:00 | [NAME] | 2013-05-13 00:00:00 | RES | 10 | Other |  | NJ | INS
 | 1 |  | [NAME] | 25 | F | 2013-05-04 00:00:00 | [NAME] | 2013-05-06 00:00:00 | [NAME] | 3 | Complete |  | PA | INS
 | 1 |  | [NAME] | 50 | F | 2013-05-04 00:00:00 | [NAME] | 2013-06-13 00:00:00 | IOP | 41 | Complete |  |  | INS
 | 1 |  | [NAME] | 36 | M | 2013-05-05 00:00:00 | [NAME] | 2013-05-10 00:00:00 | [NAME] | 6 | Complete |  | WI | INS
 | 1 |  | [NAME] | 52 | M | 2013-05-05 00:00:00 | [NAME] | 2013-06-08 00:00:00 | IOP | 32 | Complete |  | CT | INS
 | 2 |  | [NAME] | 26 | M | 2013-05-05 00:00:00 | [NAME] | 2013-05-13 00:00:00 | [NAME] | 9 | Complete |  | FL | INS
 | 1 |  | [NAME] | 25 | M | 2013-05-05 00:00:00 | [NAME] | 2013-06-14 00:00:00 | IOP | 41 | Complete |  | NJ | INS
 | 1 |  | [NAME] | 20 | F | 2013-05-06 00:00:00 | [NAME] | 2013-06-05 00:00:00 | IOP | 31 | Complete |  | FL | CASH
 | 1 |  | Nicolette | 23 | F | 2013-05-07 00:00:00 | [NAME] | 2013-07-06 00:00:00 | IOP | 61 | Complete |  | AZ | INS
 | 1 |  | [NAME] | 58 | M | 2013-05-07 00:00:00 | [NAME] | 2013-06-18 00:00:00 | IOP | 43 | Complete |  | CT | INS
 | 1 |  | Theodore | 42 | M | 2013-05-07 00:00:00 | [NAME] | 2013-05-10 00:00:00 | [NAME] | 4 | Complete |  | WV | INS
 | 1 |  | [NAME] | 52 | M | 2013-05-07 00:00:00 | [NAME] | 2013-05-17 00:00:00 | RES | 11 | Clinical |  | TX | INS
 | 1 |  | Jeffery | 39 | M | 2013-05-07 00:00:00 | [NAME] | 2013-05-11 00:00:00 | [NAME] | 5 | Complete |  | NE | INS
 | 1 |  | [NAME] | 25 | F | 2013-05-07 00:00:00 | [NAME] | 2013-05-08 00:00:00 | PHP | 2 | AMA |  | NJ | INS
 | 1 |  | [NAME] | 18 | M | 2013-05-07 00:00:00 | [NAME] | 2013-05-28 00:00:00 | PHP | 22 | Complete |  | PA | INS
 | 1 |  | [NAME] | 63 | F | 2013-05-08 00:00:00 | [NAME] | 2013-05-13 00:00:00 | [NAME] | 6 | Complete |  | FL | CASH
 | 1 |  | Omri | 21 | F | 2013-05-08 00:00:00 | [NAME] | 2013-06-12 00:00:00 | IOP | 36 | Complete |  | VA | INS
 | 1 |  | Todd | 34 | M | 2013-05-08 00:00:00 | [NAME] | 2013-05-21 00:00:00 | IOP | 14 | AMA |  | GA | CASH
 | 1 |  | Sean | 49 | M | 2013-05-08 00:00:00 | [NAME] | 2013-05-09 00:00:00 | [NAME] | 2 | Complete |  |  | CASH
 | 1 |  | Jeremy | 37 | M | 2013-05-08 00:00:00 | [NAME] | 2013-07-21 00:00:00 | IOP | 75 | Complete |  | TX | INS
 | 2 |  | Lauren | 20 | F | 2013-05-08 00:00:00 | [NAME] | 2013-05-09 00:00:00 | [NAME] | 2 | Complete |  | DE | INS
 | 1 |  | Jarryd | 29 | M | 2013-05-08 00:00:00 | [NAME] | 2013-07-03 00:00:00 | IOP | 57 | Complete |  | NY | INS
 | 1 |  | Connor | 21 | M | 2013-05-08 00:00:00 | [NAME] | 2013-05-11 00:00:00 | [NAME] | 4 | Complete |  |  | INS
 | 1 |  | [NAME] | 49 | M | 2013-05-08 00:00:00 | [NAME] | 2013-05-10 00:00:00 | [NAME] | 3 | Complete |  | MI | CASH
 | 3 |  | Rachel | 19 | F | 2013-05-08 00:00:00 | [NAME] | 2013-05-08 00:00:00 | [NAME] | 1 | AMA |  | PA | N/A
 | 1 |  | [NAME] | 53 | M | 2013-05-08 00:00:00 | [NAME] | 2013-05-15 00:00:00 | [NAME] | 8 | Complete |  | PA | INS