Spreadsheet: 271307d1381906698-how-to-sum-cells-based-off-of-a-date-range-new-test-file-2
Sheet: October 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 |  | Amber | 28 | F | 2013-10-01 00:00:00 | [NAME] |  |  |  |  |  | INS | CA
 | 1 |  | [NAME] | 23 | M | 2013-10-01 00:00:00 | [NAME] |  |  |  |  |  | CASH | PA
 | 1 |  | Lauren | 19 | F | 2013-10-01 00:00:00 | [NAME] |  |  |  |  |  | INS | AR
 | 1 |  | Christina | 23 | F | 2013-10-01 00:00:00 | [NAME] |  |  |  |  |  | INS | AR
 | 5 |  | [NAME] | 23 | M | 2013-10-01 00:00:00 | [NAME] |  |  |  |  |  | INS | NC
 | 1 |  | Chad | 40 | M | 2013-10-01 00:00:00 | [NAME] |  |  |  |  |  | INS | GA
 | 3 |  | Savanna | 26 | F | 2013-10-01 00:00:00 | [NAME] | 2013-10-01 00:00:00 | [NAME] | 1 | AMA |  | INS | FL
 | 1 |  | [NAME] | 41 | M | 2013-10-01 00:00:00 | [NAME] |  |  |  |  |  | INS | OK
 | 1 |  | [NAME] | 58 | M | 2013-10-01 00:00:00 | [NAME] |  |  |  |  |  | INS | NY
 | 3 |  | Tyler | 20 | M | 2013-10-02 00:00:00 | [NAME] |  |  |  |  |  | CASH | MI
 | 1 |  | Brode | 21 | F | 2013-10-02 00:00:00 | [NAME] | 2013-10-06 00:00:00 | [NAME] | 5 | Complete |  | INS | FL
 | 1 |  | [NAME] | 21 | M | 2013-10-02 00:00:00 | [NAME] | 2013-10-04 00:00:00 | [NAME] | 3 | Complete |  | INS | VT
 | 1 |  | Samantha | 22 | F | 2013-10-03 00:00:00 | [NAME] | 2013-10-04 00:00:00 | [NAME] | 2 | Complete |  | INS
 | 1 |  | Katelyn | 19 | F | 2013-10-02 00:00:00 | [NAME] |  |  |  |  |  | INS | MD
 | 2 |  | [NAME] | 23 | M | 2013-10-02 00:00:00 | [NAME] |  |  |  |  |  | INS | NH
 | 1 |  | Christine | 41 | F | 2013-10-02 00:00:00 | [NAME] | 2013-10-04 00:00:00 | [NAME] | 3 | Complete |  | INS | FL
 | 1 |  | [NAME] | 59 | F | 2013-10-02 00:00:00 | [NAME] |  |  |  |  |  | INS | FL
 | 6 |  | Kayleigh | 20 | F | 2013-10-02 00:00:00 | [NAME] |  |  |  |  |  | INS | OH
 | 1 |  | [NAME] | 35 | M | 2013-10-02 00:00:00 | [NAME] |  |  |  |  |  | INS | NY
 | 1 |  | Chad | 21 | M | 2013-10-02 00:00:00 | [NAME] |  |  |  |  |  | INS | NY
 | 1 |  | Justin | 24 | M | 2013-10-02 00:00:00 | [NAME] |  |  |  |  |  | INS | TN
 | 1 |  | Marcello | 31 | M | 2013-10-02 00:00:00 | [NAME] | 2013-10-05 00:00:00 | [NAME] | 4 | Complete |  | INS | MD
 | 1 |  | [NAME] | 46 | F | 2013-10-03 00:00:00 | [NAME] | 2013-10-07 00:00:00 | [NAME] | 5 | Complete |  | INS | CO
 | 1 |  | Eddie | 36 | M | 2013-10-03 00:00:00 | [NAME] | 2013-10-04 00:00:00 | [NAME] | 2 | Complete |  | INS | OK
 | 2 |  | [NAME] | 25 | M | 2013-10-03 00:00:00 | [NAME] |  |  |  |  |  | INS | PA
 | 1 |  | [NAME] | 21 | M | 2013-10-03 00:00:00 | [NAME] |  |  |  |  |  | INS | WI
 | 1 |  | [NAME] | 23 | F | 2013-10-03 00:00:00 | [NAME] | 2013-10-07 00:00:00 |  | 5 |  |  | INS | NY
 | 1 |  | [NAME] | 23 | M | 2013-10-03 00:00:00 | [NAME] |  |  |  |  |  | INS | FL
 | 2 |  | [NAME] | 22 | M | 2013-10-03 00:00:00 | [NAME] | 2013-10-04 00:00:00 | [NAME] | 2 | Complete |  | INS | IN
 | 1 |  | Penny | 52 | F | 2013-10-03 00:00:00 | [NAME] | 2013-10-03 00:00:00 | [NAME] | 1 | Medical |  | INS | OH
 | 1 |  | [NAME] | 19 | M | 2013-10-04 00:00:00 | [NAME] |  |  |  |  |  | INS | WI
 | 1 |  | [NAME] | 20 | M | 2013-10-04 00:00:00 | [NAME] | 2013-10-05 00:00:00 | [NAME] | 2 | Complete |  | INS
 | 1 |  | Cayla | 23 | F | 2013-10-04 00:00:00 | [NAME] | 2013-10-07 00:00:00 | [NAME] | 4 | Complete |  | INS | CA
 | 1 |  | [NAME] | 22 | M | 2013-10-04 00:00:00 | [NAME] | 2013-10-07 00:00:00 | [NAME] | 4 | Complete |  | INS | CT
 | 3 |  | [NAME] | 30 | M | 2013-10-04 00:00:00 | [NAME] |  |  |  |  |  | INS | PA
 | 1 |  | [NAME] | 30 | F | 2013-10-04 00:00:00 | [NAME] | 2013-10-07 00:00:00 | [NAME] | 4 | Complete |  | INS | ID
 | 2 |  | Samual | 24 | M | 2013-10-05 00:00:00 | [NAME] |  |  |  |  |  | INS | NJ
 | 1 |  | Alfredo | 33 | M | 2013-10-05 00:00:00 | [NAME] | 2013-10-07 00:00:00 | [NAME] | 3 | Complete |  | INS | SC
 | 1 |  | Kysung | 44 | M | 2013-10-06 00:00:00 | [NAME] |  |  |  |  |  | INS | NJ
 | 2 |  | [NAME] | 46 | F | 2013-10-06 00:00:00 | [NAME] |  |  |  |  |  | INS | FL
 | 2 |  | [NAME] | 24 | M | 2013-10-06 00:00:00 | [NAME] |  |  |  |  |  | INS | KY
 | 3 |  | Rebecca | 22 | F | 2013-10-06 00:00:00 | [NAME] |  |  |  |  |  | INS | FL
 | 1 |  | [NAME] | 21 | M | 2013-10-06 00:00:00 | [NAME] |  |  |  |  |  | INS
 | 1 |  | [NAME] | 61 | M | 2013-10-06 00:00:00 | [NAME] |  |  |  |  |  | CASH | VA
 | 1 |  | Jordan | 24 | F | 2013-10-06 00:00:00 | [NAME] |  |  |  |  |  | INS | WA
 | 1 |  | [NAME] | 45 | F | 2013-10-06 00:00:00 | [NAME] |  |  |  |  |  | CASH | VA
 | 1 |  | Carrie | 32 | F | 2013-10-06 00:00:00 | [NAME] |  |  |  |  |  | INS | FL
 | 2 |  | [NAME] | 21 | M | 2013-10-06 00:00:00 | [NAME] |  |  |  |  |  | INS | NH