Spreadsheet: 271189d1381858446-how-to-sum-cells-based-off-of-a-date-range-test-file-2
Sheet: September 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] | 32 | F | 2013-09-01 00:00:00 | [NAME] | 2013-09-05 00:00:00 | [NAME] | 5 | Complete |  | INS | FL
 | 3 |  | [NAME] | 25 | M | 2013-09-01 00:00:00 | [NAME] | 2013-09-03 00:00:00 | [NAME] | 3 | Complete |  | INS | NJ
 | 1 |  | [NAME] | 59 | F | 2013-09-01 00:00:00 | [NAME] |  |  |  |  |  | INS | AZ
 | 1 |  | [NAME] | 23 | M | 2013-09-01 00:00:00 | [NAME] | 2013-09-03 00:00:00 | [NAME] | 3 | AMA |  | INS | FL
 | 1 |  | Kristopher | 35 | M | 2013-09-01 00:00:00 | [NAME] | 2013-09-09 00:00:00 | [NAME] | 9 | Complete |  | CASH | KY
 | 1 |  | Rebecca | 24 | F | 2013-09-02 00:00:00 | [NAME] | 2013-09-05 00:00:00 | [NAME] | 4 | Complete |  | CASH | FL
 | 1 |  | [NAME] | 50 | F | 2013-09-02 00:00:00 | [NAME] | 2013-09-09 00:00:00 | [NAME] | 8 | Complete |  | INS | OH
 | 4 |  | [NAME] | 57 | M | 2013-09-03 00:00:00 | [NAME] | 2013-09-06 00:00:00 | [NAME] | 4 | Complete |  | CASH | FL
 | 1 |  | Eden | 52 | F | 2013-09-03 00:00:00 | [NAME] | 2013-09-09 00:00:00 | [NAME] | 7 | Complete |  | CASH | NJ
 | 1 |  | Deanne | 43 | F | 2013-09-03 00:00:00 | [NAME] | 2013-09-06 00:00:00 | [NAME] | 4 | Complete |  | INS | FL
 | 1 |  | [NAME] | 21 | M | 2013-09-04 00:00:00 | [NAME] | 2013-10-03 00:00:00 | IOP | 30 | Complete |  | INS | PA
 | 2 |  | Emma | 25 | F | 2013-09-04 00:00:00 | RES |  |  |  |  |  | INS | MI
 | 1 |  | [NAME] | 25 | M | 2013-09-04 00:00:00 | [NAME] | 2013-09-11 00:00:00 | [NAME] | 8 | Complete |  | INS | NJ
 | 2 |  | Mason | 25 | M | 2013-09-04 00:00:00 | [NAME] | 2013-09-10 00:00:00 | [NAME] | 7 | Complete |  | INS | MA
 | 2 |  | [NAME] | 25 | M | 2013-09-05 00:00:00 | [NAME] | 2013-09-06 00:00:00 | [NAME] | 2 | Complete |  | INS | DE
 | 1 |  | Ermie | 50 | F | 2013-09-05 00:00:00 | [NAME] | 2013-09-10 00:00:00 | [NAME] | 6 | Complete |  | INS | GA
 | 1 |  | [NAME] | 18 | F | 2013-09-05 00:00:00 | [NAME] | 2013-09-13 00:00:00 | [NAME] | 9 | Complete |  | INS | MI
 | 3 |  | [NAME] | 21 | M | 2013-09-05 00:00:00 | [NAME] |  |  |  |  |  | INS | FL
 | 2 |  | [NAME] | 23 | M | 2013-09-05 00:00:00 | [NAME] | 2013-09-06 00:00:00 | [NAME] | 2 | Complete |  | INS | NJ
 | 1 |  | [NAME] | 24 | F | 2013-09-05 00:00:00 | [NAME] | 2013-09-10 00:00:00 | [NAME] | 6 | Complete |  | INS | NJ
 | 1 |  | Alexandra | 21 | F | 2013-09-05 00:00:00 | [NAME] | 2013-09-14 00:00:00 | RES | 10 | Other |  | INS | NV
 | 1 |  | [NAME] | 35 | F | 2013-09-05 00:00:00 | [NAME] | 2013-09-07 00:00:00 | [NAME] | 3 | Complete |  | INS | IL
 | 1 |  | [NAME] | 50 | M | 2013-09-05 00:00:00 | [NAME] | 2013-09-08 00:00:00 | [NAME] | 4 | Complete |  | INS | OH
 | 1 |  | [NAME] | 19 | M | 2013-09-05 00:00:00 | [NAME] |  |  |  |  |  | INS | FL
 | 7 |  | [NAME] | 24 | M | 2013-09-05 00:00:00 | [NAME] | 2013-09-07 00:00:00 | [NAME] | 3 | Complete |  | INS | FL
 | 1 |  | [NAME] | 22 | M | 2013-09-06 00:00:00 | [NAME] | 2013-09-14 00:00:00 | PHP | 9 | AMA |  | INS | IL
 | 1 |  | [NAME] | 25 | M | 2013-09-06 00:00:00 | [NAME] |  |  |  |  |  | INS | NJ
 | 1 |  | Zachary | 23 | M | 2013-09-06 00:00:00 | [NAME] | 2013-09-12 00:00:00 | [NAME] | 7 | Complete |  | INS | OR
 | 1 |  | [NAME] | 41 | M | 2013-09-06 00:00:00 | [NAME] | 2013-10-07 00:00:00 |  | 32 |  |  | CASH | SC
 | 1 |  | Gavin | 23 | M | 2013-09-06 00:00:00 | [NAME] | 2013-09-13 00:00:00 | [NAME] | 8 | Complete |  | INS | PA
 | 1 |  | Keila | 25 | F | 2013-09-06 00:00:00 | [NAME] | 2013-09-13 00:00:00 | [NAME] | 8 | Complete |  | INS | FL
 | 1 |  | Channing | 49 | M | 2013-09-06 00:00:00 | [NAME] |  |  |  |  |  | INS | MD
 | 1 |  | Dominic | 23 | M | 2013-09-06 00:00:00 | [NAME] |  |  |  |  |  | INS | NJ
 | 1 |  | [NAME] | 25 | F | 2013-09-06 00:00:00 | [NAME] | 2013-09-08 00:00:00 | [NAME] | 3 | Complete |  | INS | GA
 | 1 |  | Danielle | 34 | F | 2013-09-06 00:00:00 | [NAME] |  |  |  |  |  | INS | IN
 | 2 |  | Daiva | 62 | F | 2013-09-06 00:00:00 | [NAME] | 2013-09-16 00:00:00 | IOP | 11 | AMA |  | INS | FL
 | 1 |  | [NAME] | 26 | M | 2013-09-06 00:00:00 | [NAME] | 2013-09-09 00:00:00 | [NAME] | 4 | AMA |  | INS | MA
 | 1 |  | [NAME] | 21 | M | 2013-09-06 00:00:00 | [NAME] | 2013-09-10 00:00:00 | [NAME] | 5 | Complete |  | INS | CT
 | 1 |  | [NAME] | 45 | F | 2013-09-07 00:00:00 | [NAME] | 2013-09-09 00:00:00 | [NAME] | 3 | Complete |  | INS | RI
 | 1 |  | [NAME] | 44 | F | 2013-09-07 00:00:00 | [NAME] | 2013-09-10 00:00:00 | [NAME] | 4 | Complete |  | INS | FL
 | 1 |  | [NAME] | 25 | F | 2013-09-07 00:00:00 | [NAME] |  |  |  |  |  | INS | FL
 | 1 |  | [NAME] | 57 | M | 2013-09-07 00:00:00 | [NAME] | 2013-09-12 00:00:00 | [NAME] | 6 | Complete |  | INS | VA
 | 1 |  | [NAME] | 43 | M | 2013-09-07 00:00:00 | [NAME] | 2013-09-12 00:00:00 | [NAME] | 6 |  |  | INS | NJ
 | 1 |  | [NAME] | 19 | F | 2013-09-08 00:00:00 | [NAME] | 2013-09-10 00:00:00 | [NAME] | 3 | Complete |  | INS
 | 1 |  | [NAME] | 24 | M | 2013-09-08 00:00:00 | [NAME] | 2013-09-16 00:00:00 | [NAME] | 9 | Complete |  | INS | KY
 | 1 |  | [NAME] | 22 | M | 2013-09-08 00:00:00 | [NAME] | 2013-09-16 00:00:00 | [NAME] | 9 | Complete |  | INS | IA
 | 1 |  | [NAME] | 25 | M | 2013-09-08 00:00:00 | [NAME] | 2013-09-15 00:00:00 | [NAME] | 7 | Complete |  | INS | NJ
 | 1 |  | [NAME] | 52 | F | 2013-09-08 00:00:00 | [NAME] | 2013-09-11 00:00:00 | [NAME] | 4 | Complete |  | INS | WA