Spreadsheet: 271189d1381858446-how-to-sum-cells-based-off-of-a-date-range-test-file-2
Sheet: July 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 |  | Melisa | 42 | F | 2013-07-01 00:00:00 | [NAME] | 2013-07-02 00:00:00 | [NAME] | 2 | Complete |  | INS | KY
 | 1 |  | [NAME] | 23 | M | 2013-07-01 00:00:00 | [NAME] | 2013-07-05 00:00:00 | [NAME] | 5 | Complete |  | INS | OH
 | 1 |  | Mark | 58 | M | 2013-07-01 00:00:00 | [NAME] | 2013-07-07 00:00:00 | [NAME] | 7 | Complete |  | INS | FL
 | 1 |  | [NAME] | 50 | F | 2013-07-01 00:00:00 | [NAME] | 2013-07-03 00:00:00 | [NAME] | 3 | Complete |  | CASH | FL
 | 4 |  | Carol | 42 | F | 2013-07-01 00:00:00 | [NAME] | 2013-07-09 00:00:00 | [NAME] | 9 | Complete |  | CASH | FL
 | 1 |  | [NAME] | 29 | F | 2013-07-02 00:00:00 | [NAME] | 2013-07-14 00:00:00 | PHP | 13 | Transfer |  | INS | PA
 | 2 |  | Brain | 41 | M | 2013-07-02 00:00:00 | [NAME] | 2013-07-06 00:00:00 | [NAME] | 5 | Complete |  | CASH | PA
 | 1 |  | [NAME] | 25 | M | 2013-07-02 00:00:00 | [NAME] | 2013-07-05 00:00:00 | [NAME] | 4 | Complete |  | INS | FL
 | 2 |  | [NAME] | 40 | M | 2013-07-02 00:00:00 | [NAME] | 2013-08-31 00:00:00 | IOP | 61 | Complete |  | INS | FL
 | 1 |  | Ricky | 24 | M | 2013-07-02 00:00:00 | [NAME] | 2013-07-05 00:00:00 | [NAME] | 4 | Complete |  | INS | NC
 | 3 |  | [NAME] | 28 | M | 2013-07-03 00:00:00 | RES | 2013-07-19 00:00:00 | IOP | 17 | Complete |  | INS | MA
 | 1 |  | April | 37 | F | 2013-07-03 00:00:00 | [NAME] | 2013-07-07 00:00:00 | [NAME] | 5 | Complete |  | INS | VA
 | 2 |  | [NAME] | 25 | F | 2013-07-03 00:00:00 | [NAME] | 2013-08-03 00:00:00 | RES | 32 | Clinical |  | CASH | NJ
 | 1 |  | [NAME] | 52 | M | 2013-07-03 00:00:00 | [NAME] | 2013-07-07 00:00:00 | [NAME] | 5 | Complete |  | CASH | KS
 | 2 |  | [NAME] | 25 | M | 2013-07-03 00:00:00 | [NAME] | 2013-07-06 00:00:00 | [NAME] | 4 | Complete |  | INS | MA
 | 2 |  | [NAME] | 47 | M | 2013-07-03 00:00:00 | [NAME] | 2013-07-08 00:00:00 | RES | 6 | Administrative |  | INS | CT
 | 1 |  | [NAME] | 49 | F | 2013-07-03 00:00:00 | [NAME] | 2013-08-08 00:00:00 | IOP | 37 | Complete |  | INS | GA
 | 1 |  | [NAME] | 21 | M | 2013-07-03 00:00:00 | [NAME] | 2013-08-16 00:00:00 |  | 45 |  |  | INS | MA
 | 1 |  | [NAME] | 27 | M | 2013-07-03 00:00:00 | [NAME] | 2013-08-21 00:00:00 | IOP | 60 | Complete |  | INS | WI
 | 1 |  | Justin | 23 | M | 2013-07-03 00:00:00 | [NAME] | 2013-07-05 00:00:00 | [NAME] | 3 | Complete |  | INS | VA
 | 2 |  | Kaitlyn | 21 | F | 2013-07-03 00:00:00 | [NAME] | 2013-07-12 00:00:00 | [NAME] | 10 | Complete |  | INS | OH
 | 1 |  | Jordan | 30 | M | 2013-07-03 00:00:00 | [NAME] | 2013-07-08 00:00:00 | [NAME] | 6 | Complete |  | INS | FL
 | 1 |  | Dillon | 18 | M | 2013-07-04 00:00:00 | [NAME] | 2013-07-10 00:00:00 | [NAME] | 7 | Complete |  | INS | NY
 | 1 |  | [NAME] | 22 | M | 2013-07-04 00:00:00 | [NAME] | 2013-07-11 00:00:00 | [NAME] | 8 | Complete |  | INS | NY
 | 1 |  | [NAME] | 22 | F | 2013-07-04 00:00:00 | [NAME] | 2013-09-03 00:00:00 | IOP | 52 | Complete |  | INS | GA
 | 1 |  | Alicia | 22 | F | 2013-07-04 00:00:00 | [NAME] | 2013-07-08 00:00:00 | [NAME] | 5 | Complete |  | INS | OH
 | 1 |  | Juan | 30 | M | 2013-07-04 00:00:00 | [NAME] | 2013-07-04 00:00:00 | [NAME] |  | Hospital |  | INS | GA
 | 1 |  | [NAME] | 44 | M | 2013-07-04 00:00:00 | [NAME] | 2013-08-01 00:00:00 | IOP | 29 | Complete |  | INS | MI
 | 1 |  | [NAME] | 50 | M | 2013-07-05 00:00:00 | [NAME] | 2013-09-30 00:00:00 |  | 88 | Complete |  | CASH
 | 1 |  | Nina | 25 | F | 2013-07-05 00:00:00 | [NAME] | 2013-07-16 00:00:00 | RES | 11 | Clinical |  | CASH | NJ
 | 1 |  | [NAME] | 20 | M | 2013-07-05 00:00:00 | [NAME] | 2013-08-01 00:00:00 | IOP | 28 | Complete |  | INS | OH
 | 1 |  | [NAME] | 47 | M | 2013-07-05 00:00:00 | [NAME] | 2013-08-28 00:00:00 | IOP | 55 | Complete |  | INS | HI
 | 2 |  | Kaitlin | 22 | F | 2013-07-05 00:00:00 | RES | 2013-08-02 00:00:00 | IOP | 28 | Clinical |  | CASH | FL
 | 1 |  | [NAME] T | 24 | M | 2013-07-06 00:00:00 | [NAME] | 2013-07-12 00:00:00 | [NAME] | 7 | Complete |  | INS | NJ
 | 1 |  | [NAME] | 22 | M | 2013-07-06 00:00:00 | [NAME] | 2013-09-04 00:00:00 | IOP | 61 | Complete |  | INS | NY
 | 2 |  | Juan | 30 | M | 2013-07-06 00:00:00 | [NAME] | 2013-07-10 00:00:00 | [NAME] | 5 | Complete |  | INS | GA
 | 2 |  | [NAME] | 24 | F | 2013-07-06 00:00:00 | [NAME] | 2013-07-08 00:00:00 | [NAME] | 3 | AMA |  | INS | CA
 | 1 |  | [NAME] | 21 | M | 2013-07-06 00:00:00 | [NAME] | 2013-07-09 00:00:00 | [NAME] | 4 | Complete |  | INS | VA
 | 2 |  | [NAME] | 31 | M | 2013-07-07 00:00:00 | [NAME] | 2013-07-10 00:00:00 | [NAME] | 4 | Complete |  | INS | NJ
 | 2 |  | [NAME] | 50 | M | 2013-07-07 00:00:00 | [NAME] | 2013-08-30 00:00:00 | IOP | 55 | Complete |  | INS | FL
 | 2 |  | Nathan | 23 | M | 2013-07-05 00:00:00 | RES | 2013-07-15 00:00:00 | IOP | 11 | Clinical |  | INS | FL
 | 1 |  | Darrell | 53 | M | 2013-07-08 00:00:00 | [NAME] | 2013-08-28 00:00:00 | IOP | 52 | Complete |  | INS | TN
 | 1 |  | [NAME] | 52 | M | 2013-07-08 00:00:00 | [NAME] | 2013-08-22 00:00:00 | IOP | 46 | Complete |  | INS | GA
 | 1 |  | [NAME] | 27 | M | 2013-07-08 00:00:00 | [NAME] | 2013-09-15 00:00:00 | IOP | 70 | Complete |  | INS | NJ
 | 1 |  | [NAME] | 23 | M | 2013-07-08 00:00:00 | [NAME] | 2013-07-12 00:00:00 | [NAME] | 5 | Complete |  | INS | NJ
 | 1 |  | Jasmine | 23 | F | 2013-07-09 00:00:00 | [NAME] | 2013-08-01 00:00:00 | PHP | 24 | Complete |  | INS | MD
 | 1 |  | [NAME] | 20 | F | 2013-07-09 00:00:00 | [NAME] | 2013-07-11 00:00:00 | [NAME] | 3 | Complete |  | INS | NJ
 | 1 |  | Christoper | 25 | M | 2013-07-09 00:00:00 | [NAME] | 2013-07-12 00:00:00 | [NAME] | 4 | Complete |  | INS | PA