Spreadsheet: 271224d1381866677-how-to-sum-cells-based-off-of-a-date-range-test-file-2
Sheet: April 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] | 31 | M | 2013-04-01 00:00:00 | [NAME] | 2013-05-23 00:00:00 | IOP | 53 | Complete |  | PA | INS
 | 1 |  | Chancey | 37 | F | 2013-04-01 00:00:00 | [NAME] | 2013-05-01 00:00:00 | IOP | 31 | Complete |  | WA | INS
 | 1 |  | Mindi | 34 | F | 2013-04-01 00:00:00 | [NAME] | 2013-04-25 00:00:00 | IOP | 25 | Complete |  | MI | INS
 | 4 |  | [NAME] | 32 | M | 2013-04-01 00:00:00 | [NAME] | 2013-04-06 00:00:00 | [NAME] | 7 | Complete |  | NJ | INS
 | 2 |  | Jorge | 33 | M | 2013-04-01 00:00:00 | [NAME] | 2013-05-16 00:00:00 | IOP | 46 | Complete |  | FL | INS
 | 1 |  | Kaila | 21 | F | 2013-04-02 00:00:00 | [NAME] | 2013-04-07 00:00:00 | RES | 6 | AMA |  |  | INS
 | 1 |  | [NAME] | 21 | M | 2013-04-02 00:00:00 | [NAME] | 2013-04-07 00:00:00 | RES | 6 | AMA |  | FL | INS
 | 1 |  | Franklin | 39 | M | 2013-04-02 00:00:00 | [NAME] | 2013-04-08 00:00:00 | [NAME] | 7 | Complete |  | WA | INS
 | 1 |  | [NAME] | 25 | M | 2013-04-02 00:00:00 | [NAME] | 2013-05-08 00:00:00 | IOP | 38 | Complete |  | FL | INS
 | 2 |  | [NAME] | 25 | M | 2013-04-02 00:00:00 | [NAME] | 2013-05-08 00:00:00 | IOP | 38 | Complete |  | FL | INS
 | 1 |  | [NAME] | 47 | M | 2013-04-03 00:00:00 | [NAME] | 2013-05-24 00:00:00 | IOP | 52 | Complete |  | MD | INS
 | 1 |  | [NAME] | 25 | M | 2013-04-03 00:00:00 | [NAME] | 2013-05-22 00:00:00 | IOP | 50 | Complete |  | MD | INS
 | 1 |  | [NAME] | 23 | M | 2013-04-02 00:00:00 | [NAME] | 2013-04-08 00:00:00 | [NAME] | 7 | Complete |  | FL | INS
 | 1 |  | Bradley | 29 | M | 2013-04-03 00:00:00 | [NAME] | 2013-04-10 00:00:00 | [NAME] | 8 | Complete |  |  | CASH
 | 1 |  | [NAME] | 24 | M | 2013-04-03 00:00:00 | [NAME] | 2013-04-10 00:00:00 | [NAME] | 8 | Complete |  | FL | INS
 | 1 |  | [NAME] | 29 | M | 2013-04-03 00:00:00 | [NAME] | 2013-04-27 00:00:00 | PHP | 25 | AMA |  | MD | INS
 | 2 |  | [NAME] | 23 | M | 2013-04-03 00:00:00 | [NAME] | 2013-04-09 00:00:00 | PHP | 7 | AMA |  |  | INS
 | 1 |  | [NAME] | 20 | F | 2013-04-03 00:00:00 | [NAME] | 2013-05-04 00:00:00 | IOP | 32 | Complete |  | SC | INS
 | 1 |  | [NAME] | 67 | M | 2013-04-03 00:00:00 | [NAME] | 2013-05-03 00:00:00 | PHP | 31 | Complete |  | NC | INS
 | 2 |  | [NAME] | 21 | M | 2013-04-03 00:00:00 | [NAME] | 2013-05-13 00:00:00 | IOP | 41 | Complete |  | FL | INS
 | 1 |  | Celina | 23 | F | 2013-04-04 00:00:00 | [NAME] | 2013-04-19 00:00:00 | RES | 16 | Other |  | AZ | INS
 | 1 |  | [NAME] | 19 | M | 2013-04-04 00:00:00 | [NAME] | 2013-04-10 00:00:00 | [NAME] | 7 | Complete |  | NH | INS
 | 1 |  | [NAME] | 21 | M | 2013-04-04 00:00:00 | [NAME] | 2013-04-10 00:00:00 | [NAME] | 7 | Complete |  | CT | INS
 | 3 |  | [NAME] | 21 | M | 2013-04-04 00:00:00 | [NAME] | 2013-04-06 00:00:00 | [NAME] | 3 | Complete |  | FL | INS
 | 2 |  | [NAME] | 21 | F | 2013-04-04 00:00:00 | [NAME] | 2013-05-01 00:00:00 | IOP | 28 | AMA |  | MD | INS
 | 2 |  | [NAME] | 21 | M | 2013-04-04 00:00:00 | [NAME] | 2013-04-26 00:00:00 | [NAME] | 23 | AMA |  | FL | INS
 | 1 |  | [NAME] | 29 | M | 2013-04-04 00:00:00 | [NAME] | 2013-04-23 00:00:00 | RES | 20 | AMA |  | CT | INS
 | 1 |  | [NAME] | 43 | F | 2013-04-04 00:00:00 | [NAME] | 2013-04-05 00:00:00 | [NAME] | 2 |  |  | MI | INS
 | 1 |  | [NAME] | 20 | M | 2013-04-04 00:00:00 | [NAME] | 2013-04-08 00:00:00 | [NAME] | 4 | Complete |  | FL | INS
 | 1 |  | [NAME] | 18 | M | 2013-04-04 00:00:00 | [NAME] | 2013-04-08 00:00:00 | [NAME] | 4 | Complete |  | FL | INS
 | 1 |  | [NAME] | 35 | M | 2013-04-04 00:00:00 | [NAME] | 2013-05-03 00:00:00 | RES | 30 | Complete |  | FL | CASH
 | 1 |  | [NAME] | 57 | M | 2013-04-04 00:00:00 | [NAME] | 2013-05-13 00:00:00 | PHP | 40 | Complete |  | VA | INS
 | 1 |  | [NAME] | 24 | M | 2013-04-04 00:00:00 | [NAME] | 2013-05-23 00:00:00 | IOP | 50 | Complete |  | WI | INS
 | 1 |  | [NAME] | 24 | M | 2013-04-05 00:00:00 | [NAME] | 2013-04-07 00:00:00 | [NAME] | 3 | AMA |  | NC | INS
 | 1 |  | Cory | 33 | M | 2013-04-05 00:00:00 | [NAME] | 2013-04-11 00:00:00 | [NAME] | 7 | Complete |  | FL | INS
 | 1 |  | [NAME] | 55 | M | 2013-04-06 00:00:00 | [NAME] | 2013-05-09 00:00:00 |  | 34 |  |  | MA | INS
 | 1 |  | [NAME] | 32 | M | 2013-04-06 00:00:00 | [NAME] | 2013-06-07 00:00:00 | IOP | 63 | Complete |  | MA | CASH
 | 1 |  | [NAME] | 56 | M | 2013-04-06 00:00:00 | [NAME] | 2013-04-10 00:00:00 | [NAME] | 5 | Complete |  | AZ | INS
 | 1 |  | [NAME] | 18 | M | 2013-04-06 00:00:00 | [NAME] | 2013-04-08 00:00:00 | [NAME] | 3 | Complete |  | KS | INS
 | 1 |  | Heather | 35 | F | 2013-04-06 00:00:00 | [NAME] | 2013-04-13 00:00:00 | [NAME] | 8 | Complete |  | MA | INS
 | 1 |  | [NAME] | 55 | M | 2013-04-06 00:00:00 | [NAME] | 2013-04-08 00:00:00 | [NAME] | 3 | Complete |  | NJ | INS
 | 1 |  | [NAME] | 59 | F | 2013-04-07 00:00:00 | [NAME] | 2013-04-11 00:00:00 | [NAME] | 5 | Complete |  | NY | INS
 | 1 |  | [NAME] | 23 | M | 2013-04-07 00:00:00 | [NAME] | 2013-05-17 00:00:00 | IOP | 41 | Complete |  | TX | INS
 | 2 |  | [NAME] | 26 | M | 2013-04-08 00:00:00 | [NAME] | 2013-04-15 00:00:00 | [NAME] | 8 | Complete |  | FL | INS
 | 1 |  | Rebecca | 37 | F | 2013-04-08 00:00:00 | [NAME] | 2013-05-01 00:00:00 | IOP | 24 | Complete |  | OH | INS
 | 2 |  | [NAME] | 20 | F | 2013-04-08 00:00:00 | [NAME] | 2013-04-15 00:00:00 | RES | 8 | AMA |  | NJ | INS
 | 1 |  | [NAME] | 39 | M | 2013-04-09 00:00:00 | [NAME] | 2013-04-15 00:00:00 | [NAME] | 7 | Complete |  | IL | INS
 | 2 |  | [NAME] | 25 | F | 2013-04-09 00:00:00 | [NAME] | 2013-04-11 00:00:00 | [NAME] | 3 | Hospital |  | CT | INS