Spreadsheet: 271327d1381913724-how-to-sum-cells-based-off-of-a-date-range-new-test-file-2
Sheet: February 2013

 | Re | Last | First |  |  |  | LOC |  | LOC | LOS |  | Discharge | Geograhpy | Method of
MR# | Admit | Name | Name | Age | Sex | DOA | (Admissions) | DOD | (Discharge) | (#of days) | TOD | To |  | Payment | LOS
 | 2 |  | Chad | 38 | M | 2013-02-01 00:00:00 | [NAME] | 2013-02-03 00:00:00 | [NAME] | 3 |  |  | TX | INS
 | 1 |  | Rebecca | 26 | F | 2013-02-01 00:00:00 | [NAME] | 2013-04-08 00:00:00 | IOP | 66 | Complete |  | TN | INS
 | 2 |  | [NAME] | 23 | M | 2013-02-01 00:00:00 | TX | 2013-03-01 00:00:00 | IOP | 29 | Complete |  |  | INS
 | 1 |  | Jordan | 23 | F | 2013-02-02 00:00:00 | [NAME] | 2013-03-29 00:00:00 | IOP | 56 | Complete |  | NY | INS
 | 1 |  | Troy | 23 | M | 2013-02-02 00:00:00 | [NAME] | 2013-02-05 00:00:00 | [NAME] | 4 | Complete |  | FL | INS
 | 1 |  | Rhea | 25 | F | 2013-02-02 00:00:00 | [NAME] | 2013-03-15 00:00:00 | IOP | 42 | Clinical |  | RI | INS
 | 2 |  | [NAME] | 20 | F | 2013-02-02 00:00:00 | [NAME] | 2013-02-21 00:00:00 | IOP | 20 | AMA |  | MD | INS
 | 1 |  | [NAME] | 19 | M | 2013-02-02 00:00:00 | TX | 2013-03-22 00:00:00 | IOP | 49 | Complete |  |  | INS
 | 1 |  | Shandee | 20 | F | 2013-02-02 00:00:00 | TX | 2013-03-18 00:00:00 | IOP | 45 | Complete |  |  | INS
 | 1 |  | Sean | 23 | M | 2013-02-03 00:00:00 | [NAME] | 2013-02-15 00:00:00 | PHP | 13 | Clinical |  | TX | CASH
 | 1 |  | Hector | 24 | M | 2013-02-03 00:00:00 | [NAME] | 2013-03-13 00:00:00 | IOP | 39 | Complete |  |  | INS
 | 2 |  | [NAME] | 21 | M | 2013-02-04 00:00:00 | [NAME] | 2013-03-02 00:00:00 | RES | 27 | Other |  | NV | CASH
 | 1 |  | [NAME] | 26 | M | 2013-02-04 00:00:00 | [NAME] | 2013-03-07 00:00:00 | IOP | 32 | Complete |  | NJ | INS
 | 2 |  | [NAME] | 38 | M | 2013-02-04 00:00:00 | [NAME] | 2013-02-11 00:00:00 | [NAME] | 8 | Complete |  | TX | INS
 | 1 |  | [NAME] | 44 | M | 2013-02-04 00:00:00 | [NAME] | 2013-03-06 00:00:00 | IOP | 31 | Complete |  | CT | INS
 | 1 |  | [NAME] | 22 | F | 2013-02-05 00:00:00 | [NAME] | 2013-03-14 00:00:00 | IOP | 38 | Complete |  | OH | INS
 | 1 |  | [NAME] | 20 | F | 2013-02-05 00:00:00 | [NAME] | 2013-02-08 00:00:00 | [NAME] | 4 | Complete |  | NJ | INS
 | 1 |  | [NAME] | 51 | F | 2013-02-05 00:00:00 | [NAME] | 2013-02-11 00:00:00 | [NAME] | 7 | Complete |  | MO | INS
 | 2 |  | Briar | 18 | M | 2013-02-05 00:00:00 | [NAME] | 2013-02-25 00:00:00 | IOP | 21 | Complete |  | MO | INS
 | 3 |  | [NAME] | 23 | M | 2013-02-05 00:00:00 | [NAME] | 2013-02-12 00:00:00 | [NAME] | 8 | Complete |  | NY | CASH
 | 1 |  | Scot | 54 | M | 2013-02-05 00:00:00 | [NAME] | 2013-02-08 00:00:00 | [NAME] | 4 |  |  | TX | INS
 | 1 |  | [NAME] | 54 | F | 2013-02-06 00:00:00 | [NAME] | 2013-03-14 00:00:00 | PHP | 37 | Complete |  |  | INS
 | 2 |  | Rachel | 18 | F | 2013-02-06 00:00:00 | [NAME] | 2013-02-08 00:00:00 | PHP | 3 | AMA |  | PA | INS
 | 1 |  | Derek | 24 | M | 2013-02-06 00:00:00 | TX | 2013-03-01 00:00:00 | IOP | 24 | Complete |  |  | INS
 | 4 |  | [NAME] | 20 | M | 2013-02-06 00:00:00 | TX | 2013-03-25 00:00:00 | IOP | 48 | Complete |  | GA | INS
 | 1 |  | Fred | 43 | M | 2013-02-06 00:00:00 | [NAME] | 2013-02-11 00:00:00 | [NAME] | 6 | Complete |  | MD | INS
 | 2 |  | [NAME] | 24 | M | 2013-02-06 00:00:00 | [NAME] | 2013-02-10 00:00:00 | [NAME] | 5 | Complete |  | MA | INS
 | 1 |  | [NAME] | 56 | F | 2013-02-06 00:00:00 | [NAME] | 2013-02-13 00:00:00 | [NAME] | 8 | Complete |  | FL | CASH
 | 1 |  | Rory | 24 | M | 2013-02-06 00:00:00 | [NAME] | 2013-02-12 00:00:00 | [NAME] | 7 | Complete |  | PA | INS
 | 1 |  | Todd | 26 | M | 2013-02-06 00:00:00 | [NAME] | 2013-02-11 00:00:00 | [NAME] | 6 | Complete |  | VT | INS
 | 1 |  | [NAME] | 21 | M | 2013-02-07 00:00:00 | [NAME] | 2013-03-13 00:00:00 | IOP | 35 | Complete |  | NH | INS
 | 1 |  | [NAME] | 19 | M | 2013-02-07 00:00:00 | [NAME] | 2013-02-22 00:00:00 | RES | 16 |  |  | MN | INS
 | 1 |  | [NAME] | 22 | F | 2013-02-07 00:00:00 | [NAME] | 2013-03-13 00:00:00 | IOP | 35 | Complete |  | PA | INS
 | 1 |  | Gregory | 26 | M | 2013-02-07 00:00:00 | [NAME] | 2013-03-21 00:00:00 | IOP | 43 | Complete |  | PA | CASH
 | 1 |  | Amanda | 23 | F | 2013-02-07 00:00:00 | [NAME] | 2013-03-20 00:00:00 | PHP | 42 | Complete |  | IN | INS
 | 3 |  | Chad | 38 | M | 2013-02-08 00:00:00 | [NAME] | 2013-03-02 00:00:00 | IOP | 23 | Complete |  | TX | INS
 | 1 |  | [NAME] | 23 | F | 2013-02-08 00:00:00 | [NAME] | 2013-02-14 00:00:00 | [NAME] | 7 | Complete |  | IL | INS
 | 1 |  | [NAME] | 27 | M | 2013-02-08 00:00:00 | [NAME] | 2013-02-14 00:00:00 | [NAME] | 7 | Complete |  | IL | CASH
 | 1 |  | [NAME] | 50 | F | 2013-02-08 00:00:00 | [NAME] | 2013-03-14 00:00:00 | IOP | 35 | Complete |  | CA | INS
 | 1 |  | Jessica | 21 | F | 2013-02-09 00:00:00 | [NAME] | 2013-02-15 00:00:00 | [NAME] | 7 | Complete |  | OH | INS
 | 1 |  | Ashlee | 24 | F | 2013-02-09 00:00:00 | [NAME] | 2013-02-16 00:00:00 | [NAME] | 8 | Complete |  | FL | INS
 | 1 |  | [NAME] | 18 | F | 2013-02-09 00:00:00 | [NAME] | 2013-02-11 00:00:00 | [NAME] | 3 |  |  | FL | INS
 | 1 |  | [NAME] | 27 | M | 2013-02-09 00:00:00 | [NAME] | 2013-02-12 00:00:00 | IOP | 4 | AMA |  | NC | CASH
 | 1 |  | Stephen | 44 | M | 2013-02-09 00:00:00 | [NAME] | 2013-03-05 00:00:00 | PHP | 25 | Complete |  | VA | INS
 | 1 |  | [NAME] | 19 | M | 2013-02-09 00:00:00 | [NAME] | 2013-02-18 00:00:00 | [NAME] | 10 | Complete |  | TN | INS
 | 1 |  | [NAME] | 19 | F | 2013-02-10 00:00:00 | [NAME] | 2013-02-13 00:00:00 | [NAME] | 4 | Complete |  | NJ | INS
 | 1 |  | [NAME] | 19 | M | 2013-02-10 00:00:00 | [NAME] | 2013-02-12 00:00:00 | [NAME] | 3 | Complete |  | MD | INS
 | 1 |  | Jordan | 26 | M | 2013-02-10 00:00:00 | [NAME] | 2013-02-12 00:00:00 | [NAME] | 3 |  |  | CA | INS