Spreadsheet: 271189d1381858446-how-to-sum-cells-based-off-of-a-date-range-test-file-2
Sheet: June 2013

 | Re | Last | First |  |  |  | LOC |  | LOC | LOS |  | Discharge | Method of | Geograhpy
MR# | Admit | Name | Name | Age | Sex | DOA | (Admissions) | DOD | (Discharge) | (#of days) | TOD | To | Payment |  | LOS
 | 1 |  | [NAME] | 56 | M | 2013-06-01 00:00:00 | [NAME] | 2013-06-07 00:00:00 | [NAME] | 7 | Complete |  | INS
 | 1 |  | [NAME] | 38 | M | 2013-06-01 00:00:00 | [NAME] | 2013-06-07 00:00:00 | [NAME] | 7 | Complete |  | INS | OH
 | 1 |  | [NAME] | 21 | M | 2013-06-01 00:00:00 | [NAME] | 2013-06-01 00:00:00 | [NAME] | 1 | AMA |  | INS | NJ
 | 1 |  | Tanya | 43 | F | 2013-06-01 00:00:00 | [NAME] | 2013-06-05 00:00:00 | [NAME] | 5 | Complete |  | INS | SC
 | 2 |  | Chelsea | 21 | F | 2013-06-01 00:00:00 | [NAME] | 2013-06-05 00:00:00 | [NAME] | 5 | Complete |  | INS | FL
 | 1 |  | [NAME] | 23 | M | 2013-06-01 00:00:00 | [NAME] | 2013-06-10 00:00:00 | PHP | 10 | Clinical |  | INS | NY
 | 2 |  | [NAME] | 35 | M | 2013-06-01 00:00:00 | [NAME] | 2013-07-03 00:00:00 | RES | 33 | Complete |  | CASH | FL
 | 1 |  | [NAME] | 20 | F | 2013-06-01 00:00:00 | [NAME] | 2013-06-08 00:00:00 | PHP | 8 | AMA |  | INS | NC
 | 1 |  | Alyssa | 20 | F | 2013-06-01 00:00:00 | [NAME] | 2013-06-06 00:00:00 | [NAME] | 6 | Complete |  | INS | MD
 | 2 |  | [NAME] | 21 | F | 2013-06-01 00:00:00 | [NAME] | 2013-06-25 00:00:00 | IOP | 25 | Complete |  | INS | NY
 | 2 |  | [NAME] | 21 | M | 2013-06-02 00:00:00 | [NAME] | 2013-06-03 00:00:00 | [NAME] | 2 | Complete |  | INS | NY
 | 2 |  | Justin | 24 | M | 2013-06-02 00:00:00 | [NAME] | 2013-07-01 00:00:00 | IOP | 30 | Clinical |  | INS | NC
 | 1 |  | [NAME] | 21 | M | 2013-06-02 00:00:00 | [NAME] | 2013-07-03 00:00:00 | PHP | 32 | Complete |  | INS | NC
 | 1 |  | [NAME] | 31 | F | 2013-06-02 00:00:00 | [NAME] | 2013-06-05 00:00:00 | [NAME] | 4 | Hospital |  | CASH | NY
 | 2 |  | [NAME] | 30 | M | 2013-06-03 00:00:00 | [NAME] | 2013-06-10 00:00:00 | [NAME] | 8 | Complete |  | Scholarship | FL
 | 1 |  | [NAME] | 47 | M | 2013-06-03 00:00:00 | [NAME] | 2013-06-10 00:00:00 | [NAME] | 8 | Complete |  | INS | FL
 | 1 |  | Bartholomew | 29 | M | 2013-06-03 00:00:00 | [NAME] | 2013-06-10 00:00:00 | [NAME] | 8 | Complete |  | INS | FL
 | 1 |  | Lauren | 19 | F | 2013-06-03 00:00:00 | [NAME] | 2013-06-12 00:00:00 | [NAME] | 10 | Complete |  | INS | AZ
 | 1 |  | [NAME] | 24 | M | 2013-06-03 00:00:00 | [NAME] | 2013-06-08 00:00:00 | [NAME] | 6 | Complete |  | INS | FL
 | 1 |  | [NAME] | 51 | F | 2013-06-03 00:00:00 | [NAME] | 2013-07-03 00:00:00 | IOP | 31 | Complete |  | INS | OH
 | 1 |  | [NAME] | 26 | M | 2013-06-04 00:00:00 | [NAME] | 2013-06-10 00:00:00 | [NAME] | 7 | Complete |  | INS | NJ
 | 1 |  | Tiffany | 30 | F | 2013-06-04 00:00:00 | [NAME] | 2013-06-10 00:00:00 | [NAME] | 7 | Complete |  | INS | OK
 | 1 |  | [NAME] | 53 | F | 2013-06-04 00:00:00 | [NAME] | 2013-06-04 00:00:00 | [NAME] | 1 | Hospital |  | INS | OK
 | 1 |  | [NAME] | 25 | F | 2013-06-04 00:00:00 | [NAME] | 2013-07-03 00:00:00 | RES | 30 | Complete |  | CASH
 | 2 |  | Connor | 21 | M | 2013-06-04 00:00:00 | [NAME] | 2013-07-02 00:00:00 | PHP | 29 | AMA |  | INS
 | 1 |  | [NAME] | 25 | M | 2013-06-04 00:00:00 | [NAME] | 2013-06-10 00:00:00 | [NAME] | 7 | Complete |  | INS | MD
 | 1 |  | [NAME] | 25 | M | 2013-06-04 00:00:00 | [NAME] | 2013-06-10 00:00:00 | [NAME] | 7 | Complete |  | INS | VA
 | 1 |  | [NAME] | 43 | F | 2013-06-05 00:00:00 | [NAME] | 2013-06-07 00:00:00 | [NAME] | 3 | Complete |  | INS | MJ
 | 1 |  | Whitney | 18 | F | 2013-06-05 00:00:00 | [NAME] | 2013-06-11 00:00:00 | [NAME] | 7 | Complete |  | INS
 | 1 |  | [NAME] | 21 | F | 2013-06-05 00:00:00 | [NAME] | 2013-06-11 00:00:00 | [NAME] | 7 | Complete |  | INS | MO
 | 1 |  | [NAME] | 22 | M | 2013-06-05 00:00:00 | [NAME] | 2013-06-12 00:00:00 | PHP | 8 | AMA |  | INS | CT
 | 1 |  | Emily | 28 | F | 2013-06-05 00:00:00 | [NAME] | 2013-07-13 00:00:00 | IOP | 39 | Complete |  | CASH | LA
 | 4 |  | [NAME] | 21 | M | 2013-06-05 00:00:00 | [NAME] | 2013-06-12 00:00:00 | [NAME] | 8 | Complete |  | INS | NY
 | 3 |  | [NAME] | 31 | F | 2013-06-06 00:00:00 | [NAME] | 2013-06-26 00:00:00 | IOP | 21 | Clinical |  | INS | PA
 | 1 |  | [NAME] | 24 | M | 2013-06-06 00:00:00 | [NAME] | 2013-06-08 00:00:00 | [NAME] | 3 | Complete |  | INS | WA
 | 1 |  | [NAME] | 38 | F | 2013-06-06 00:00:00 | [NAME] | 2013-06-12 00:00:00 | [NAME] | 7 | Complete |  | INS | NC
 | 1 |  | [NAME] | 27 | M | 2013-06-06 00:00:00 | [NAME] | 2013-08-01 00:00:00 | PHP | 57 | Complete |  | CASH | MI
 | 2 |  | Julia | 25 | F | 2013-06-06 00:00:00 | [NAME] | 2013-06-13 00:00:00 | [NAME] | 8 | Complete |  | INS | NJ
 | 2 |  | [NAME] | 22 | M | 2013-06-06 00:00:00 | [NAME] | 2013-06-14 00:00:00 | [NAME] | 9 | Complete |  | INS | CT
 | 1 |  | [NAME] | 44 | F | 2013-06-06 00:00:00 | [NAME] | 2013-07-05 00:00:00 | IOP | 30 | Complete |  | CASH | CO
 | 1 |  | [NAME] | 21 | F | 2013-06-06 00:00:00 | [NAME] | 2013-06-25 00:00:00 | IOP | 20 | Relapse |  | INS | NJ
 | 1 |  | [NAME] | 27 | F | 2013-06-06 00:00:00 | [NAME] | 2013-06-11 00:00:00 | [NAME] | 6 | Complete |  | INS | MD
 | 1 |  | [NAME] | 60 | M | 2013-06-07 00:00:00 | [NAME] | 2013-07-18 00:00:00 | IOP | 42 | Complete |  | INS | NC
 | 1 |  | Travis | 37 | M | 2013-06-07 00:00:00 | [NAME] | 2013-06-11 00:00:00 | [NAME] | 5 | Complete |  | INS | NC
 | 2 |  | [NAME] | 21 | F | 2013-06-04 00:00:00 | RES | 2013-07-31 00:00:00 | IOP | 58 | Complete |  | CASH | FL
 | 1 |  | [NAME] | 35 | M | 2013-06-07 00:00:00 | [NAME] | 2013-06-10 00:00:00 | [NAME] | 4 | Complete |  | INS | PA
 | 1 |  | London | 41 | M | 2013-06-07 00:00:00 | [NAME] | 2013-06-13 00:00:00 | [NAME] | 7 | Complete |  | INS | NC
 | 1 |  | [NAME] | 20 | M | 2013-06-07 00:00:00 | [NAME] | 2013-07-11 00:00:00 | IOP | 35 | Complete |  | INS | CA