Spreadsheet: 271307d1381906698-how-to-sum-cells-based-off-of-a-date-range-new-test-file-2
Sheet: August 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
 | 2 |  | [NAME] | 20 | M | 2013-08-01 00:00:00 | [NAME] | 2013-08-02 00:00:00 | RES | 2 | AMA |  | INS | NJ
 | 1 |  | [NAME] | 23 | F | 2013-08-01 00:00:00 | [NAME] | 2013-08-02 00:00:00 | [NAME] | 2 | Complete |  | INS | AL
 | 1 |  | [NAME] | 21 | F | 2013-08-01 00:00:00 | [NAME] | 2013-08-02 00:00:00 | [NAME] | 2 | Complete |  | INS | NH
 | 1 |  | Shawn | 49 | M | 2013-08-01 00:00:00 | [NAME] | 2013-09-04 00:00:00 | IOP | 35 | Complete |  | INS | IN
 | 1 |  | [NAME] | 29 | M | 2013-08-01 00:00:00 | [NAME] | 2013-08-07 00:00:00 | [NAME] | 7 | Complete |  | INS | MA
 | 1 |  | Jon | 22 | M | 2013-08-01 00:00:00 | [NAME] | 2013-08-06 00:00:00 | RES | 6 | AMA |  | INS | NY
 | 1 |  | Nichole | 23 | F | 2013-08-01 00:00:00 | [NAME] |  |  |  |  |  | INS | MA
 | 1 |  | [NAME] | 31 | M | 2013-08-01 00:00:00 | [NAME] | 2013-08-03 00:00:00 | [NAME] | 3 | Hospital |  | INS | MA
 | 1 |  | Kayla | 20 | F | 2013-08-02 00:00:00 | [NAME] | 2013-08-09 00:00:00 | [NAME] | 8 | Complete |  | INS | FL
 | 1 |  | [NAME] | 20 | M | 2013-08-02 00:00:00 | [NAME] | 2013-08-07 00:00:00 | [NAME] | 6 | Complete |  | INS | TX
 | 2 |  | Nolan | 24 | M | 2013-08-02 00:00:00 | [NAME] |  |  |  |  |  | INS | NY
 | 1 |  | Stephen | 63 | M | 2013-08-02 00:00:00 | [NAME] | 2013-08-19 00:00:00 | RES | 18 | AMA |  | INS | AZ
 | 1 |  | [NAME] | 56 | M | 2013-08-03 00:00:00 | [NAME] | 2013-08-04 00:00:00 | [NAME] | 2 | Complete |  | INS | SC
 | 1 |  | [NAME] | 30 | F | 2013-08-03 00:00:00 | [NAME] | 2013-09-06 00:00:00 | RES | 35 | Complete |  | CASH | LA
 | 1 |  | Kiyoka | 28 | F | 2013-08-03 00:00:00 | [NAME] | 2013-08-14 00:00:00 | [NAME] | 12 | Complete |  | CASH
 | 1 |  | Krystina | 25 | F | 2013-08-03 00:00:00 | [NAME] | 2013-08-14 00:00:00 | [NAME] | 12 | AMA |  | INS | NJ
 | 1 |  | [NAME] | 30 | M | 2013-08-03 00:00:00 | [NAME] | 2013-10-04 00:00:00 | IOP | 63 | Complete |  | INS | FL
 | 1 |  | Christina | 24 | F | 2013-08-04 00:00:00 | [NAME] | 2013-08-12 00:00:00 | [NAME] | 9 | Complete |  | INS | OR
 | 3 |  | [NAME] | 39 | M | 2013-08-04 00:00:00 | [NAME] | 2013-09-23 00:00:00 | PHP | 51 | Complete |  | SCHOLARSHIP | FL
 | 1 |  | [NAME] | 23 | M | 2013-08-04 00:00:00 | [NAME] | 2013-08-16 00:00:00 | IOP | 13 | Relapse |  | INS | FL
 | 1 |  | Terrence | 29 | M | 2013-08-04 00:00:00 | [NAME] | 2013-08-11 00:00:00 | [NAME] | 8 | Complete |  | INS | NJ
 | 1 |  | Antoine | 52 | M | 2013-08-05 00:00:00 | [NAME] | 2013-08-11 00:00:00 | [NAME] | 7 | Complete |  | INS | NJ
 | 1 |  | Lillian | 22 | F | 2013-08-05 00:00:00 | [NAME] | 2013-08-09 00:00:00 | [NAME] | 5 | Complete |  | INS | WA
 | 1 |  | Stephen | 24 | M | 2013-08-05 00:00:00 | [NAME] | 2013-09-04 00:00:00 | IOP | 31 | Complete |  | INS | FL
 | 1 |  | [NAME] | 24 | M | 2013-08-05 00:00:00 | [NAME] | 2013-08-07 00:00:00 | [NAME] | 4 | AMA |  | INS
 | 5 |  | [NAME] | 24 | M | 2013-08-05 00:00:00 | [NAME] | 2013-08-12 00:00:00 | [NAME] | 8 | Complete |  | INS | NJ
 | 2 |  | [NAME] | 27 | M | 2013-08-05 00:00:00 | [NAME] |  |  |  |  |  | INS | MA
 | 2 |  | [NAME] | 31 | M | 2013-08-06 00:00:00 | [NAME] | 2013-08-08 00:00:00 | [NAME] | 3 | Complete |  | INS | MA
 | 1 |  | Shelby | 18 | F | 2013-08-06 00:00:00 | [NAME] | 2013-08-08 00:00:00 | [NAME] | 3 | Complete |  | INS | IN
 | 1 |  | Christina | 30 | F | 2013-08-06 00:00:00 | [NAME] | 2013-09-04 00:00:00 | RES | 30 | Complete |  | INS | IL
 | 1 |  | [NAME] | 46 | M | 2013-08-06 00:00:00 | [NAME] | 2013-08-08 00:00:00 | [NAME] | 3 | Complete |  | INS | NY
 | 1 |  | Yvette | 45 | F | 2013-08-06 00:00:00 | [NAME] | 2013-08-13 00:00:00 | [NAME] | 8 | Complete |  | INS | NY
 | 1 |  | [NAME] | 23 | F | 2013-08-06 00:00:00 | [NAME] | 2013-08-08 00:00:00 | [NAME] | 3 | Complete |  | INS | NJ
 | 1 |  | [NAME] | 19 | F | 2013-08-06 00:00:00 | [NAME] | 2013-08-11 00:00:00 | [NAME] | 6 | Complete |  | CASH | MD
 | 1 |  | [NAME] | 44 | M | 2013-08-06 00:00:00 | [NAME] | 2013-08-22 00:00:00 | PHP | 17 | Other |  | INS | KY
 | 1 |  | [NAME] | 33 | M | 2013-08-07 00:00:00 | [NAME] | 2013-09-20 00:00:00 |  | 45 |  |  | INS | ND
 | 1 |  | Shane | 21 | M | 2013-08-07 00:00:00 | [NAME] | 2013-09-30 00:00:00 | IOP | 55 | Complete |  | INS | NY
 | 2 |  | Marcques | 18 | M | 2013-08-07 00:00:00 | RES | 2013-08-15 00:00:00 | IOP | 9 | AMA |  | INS | VA
 | 1 |  | [NAME] | 34 | F | 2013-08-07 00:00:00 | [NAME] | 2013-08-13 00:00:00 | [NAME] | 7 | Complete |  | CASH | VA
 | 1 |  | Cory | 38 | M | 2013-08-07 00:00:00 | [NAME] | 2013-08-09 00:00:00 | [NAME] | 3 | Complete |  | INS | FL
 | 2 |  | Chasity | 20 | F | 2013-08-07 00:00:00 | [NAME] | 2013-08-08 00:00:00 | [NAME] | 2 | Complete |  | INS | KY
 | 1 |  | Brent | 24 | M | 2013-08-07 00:00:00 | [NAME] | 2013-08-09 00:00:00 | [NAME] | 3 | Complete |  | INS | KY
 | 1 |  | [NAME] | 28 | M | 2013-08-07 00:00:00 | [NAME] | 2013-08-11 00:00:00 | [NAME] | 5 | Complete |  | CASH | FL
 | 2 |  | [NAME] | 43 | M | 2013-08-07 00:00:00 | [NAME] | 2013-09-06 00:00:00 | IOP | 31 | Complete |  | INS | FL
 | 1 |  | Chloe | 21 | F | 2013-08-07 00:00:00 | [NAME] | 2013-08-14 00:00:00 | [NAME] | 7 | Complete |  | INS | VA
 | 1 |  | Rodrecas | 22 | M | 2013-08-07 00:00:00 | [NAME] | 2013-08-12 00:00:00 | [NAME] | 6 | Complete |  | INS | GA
 | 2 |  | Lloyd | 22 | M | 2013-08-08 00:00:00 | [NAME] | 2013-08-13 00:00:00 | [NAME] | 6 | Complete |  | INS | NJ
 | 1 |  | [NAME] | 18 | F | 2013-08-08 00:00:00 | [NAME] | 2013-08-12 00:00:00 | PHP | 5 | AMA |  | INS | NJ