Spreadsheet: 271327d1381913724-how-to-sum-cells-based-off-of-a-date-range-new-test-file-2
Sheet: March 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
 | 1 |  | [NAME] | 41 | M | 2013-03-01 00:00:00 | [NAME] | 2013-04-09 00:00:00 | IOP | 40 | Clinical |  | CT | INS
 | 1 |  | Michelle | 26 | F | 2013-03-01 00:00:00 | [NAME] | 2013-04-11 00:00:00 | IOP | 42 | Complete |  | CA | INS
 | 1 |  | [NAME] | 23 | M | 2013-03-01 00:00:00 | [NAME] | 2013-03-19 00:00:00 | IOP | 19 | AMA |  | MD | INS
 | 1 |  | [NAME] | 57 | M | 2013-03-01 00:00:00 | [NAME] | 2013-03-24 00:00:00 | PHP | 24 | AMA |  | TN | INS
 | 1 |  | [NAME] | 22 | M | 2013-03-01 00:00:00 | [NAME] | 2013-06-24 00:00:00 | IOP | 116 | Complete |  | MA | INS
 | 2 |  | [NAME] | 22 | M | 2013-03-01 00:00:00 | [NAME] | 2013-03-12 00:00:00 | PHP | 12 | AMA |  | NJ | INS
 | 1 |  | [NAME] | 30 | M | 2013-03-01 00:00:00 | [NAME] | 2013-03-06 00:00:00 | [NAME] | 6 | Complete |  | CO | INS
 | 2 |  | Eva | 23 | F | 2013-03-02 00:00:00 | [NAME] | 2013-04-12 00:00:00 | IOP | 42 | Complete |  | NY | INS
 | 3 |  | [NAME] | 25 | M | 2013-03-02 00:00:00 | [NAME] | 2013-04-02 00:00:00 | IOP | 30 | AMA |  | MA | INS
 | 1 |  | Clarence | 21 | M | 2013-03-02 00:00:00 | [NAME] | 2013-05-31 00:00:00 | IOP | 91 | Complete |  | NY | CASH
 | 1 |  | Samantha | 21 | F | 2013-03-03 00:00:00 | [NAME] | 2013-04-18 00:00:00 | IOP | 47 | Complete |  | MN | INS
 | 1 |  | [NAME] | 23 | M | 2013-03-10 00:00:00 | [NAME] | 2013-03-13 00:00:00 | IOP | 3 | Other |  | NJ | INS
 | 1 |  | [NAME] | 22 | M | 2013-03-03 00:00:00 | [NAME] | 2013-04-18 00:00:00 | IOP | 47 | Complete |  | NJ
 | 1 |  | [NAME] | 20 | F | 2013-03-03 00:00:00 | [NAME] | 2013-03-10 00:00:00 | [NAME] | 8 | Complete |  | PA | INS
 | 1 |  | Chelsea | 19 | F | 2013-03-03 00:00:00 | [NAME] | 2013-03-15 00:00:00 | RES | 13 | AMA |  | RI | INS
 | 1 |  | [NAME] | 21 | M | 2013-03-04 00:00:00 | [NAME] | 2013-04-16 00:00:00 | IOP | 44 | Complete |  | FL | INS
 | 1 |  | [NAME] | 22 | M | 2013-03-04 00:00:00 | [NAME] | 2013-03-19 00:00:00 | IOP | 16 | AMA |  | NY | INS
 | 1 |  | [NAME] | 25 | M | 2013-03-04 00:00:00 | [NAME] | 2013-06-03 00:00:00 | IOP | 92 | Complete |  | CT | INS
 | 1 |  | Adriana | 21 | F | 2013-03-04 00:00:00 | [NAME] | 2013-04-06 00:00:00 | IOP | 32 | Complete |  |  | INS
 | 1 |  | [NAME] | 24 | M | 2013-03-04 00:00:00 | [NAME] | 2013-03-19 00:00:00 | PHP | 16 | AMA |  | FL | INS
 | 1 |  | [NAME] | 33 | M | 2013-03-04 00:00:00 | [NAME] | 2013-04-03 00:00:00 | PHP | 31 | Complete |  | NH | INS
 | 3 |  | Adem | 19 | M | 2013-03-04 00:00:00 | [NAME] | 2013-03-07 00:00:00 | [NAME] | 4 | Complete |  |  | INS
 | 1 |  | [NAME] | 40 | F | 2013-03-04 00:00:00 | [NAME] | 2013-03-27 00:00:00 | IOP | 24 | AMA |  | RI | INS
 | 1 |  | Brett | 27 | M | 2013-03-04 00:00:00 | [NAME] | 2013-03-08 00:00:00 | [NAME] | 5 | Complete |  | NH | CASH
 | 3 |  | Rebekah | 22 | F | 2013-03-05 00:00:00 | [NAME] | 2013-03-11 00:00:00 | [NAME] | 7 | Complete |  | NJ | INS
 | 1 |  | [NAME] | 20 | M | 2013-03-05 00:00:00 | [NAME] | 2013-06-05 00:00:00 | IOP | 93 | Complete |  | CO | CASH
 | 3 |  | Sara | 28 | F | 2013-03-05 00:00:00 | [NAME] | 2013-03-11 00:00:00 | [NAME] | 7 | Complete |  | MD | INS
 | 1 |  | Rachel | 41 | F | 2013-03-05 00:00:00 | [NAME] | 2013-03-14 00:00:00 | RES | 10 | Other |  | MO | INS
 | 1 |  | [NAME] | 55 | M | 2013-03-05 00:00:00 | [NAME] | 2013-04-15 00:00:00 | IOP | 42 | Other |  | AZ | INS
 | 1 |  | Crysta | 19 | F | 2013-03-05 00:00:00 | [NAME] | 2013-04-18 00:00:00 | IOP | 45 | Complete |  | DE | INS
 | 2 |  | [NAME] | 28 | M | 2013-03-05 00:00:00 | [NAME] | 2013-03-19 00:00:00 | RES | 15 | AMA |  | MA | CASH
 | 1 |  | [NAME] | 21 | F | 2013-03-05 00:00:00 | [NAME] | 2013-03-11 00:00:00 | [NAME] | 7 | Complete |  | NY | INS
 | 2 |  | Chelsea | 19 | F | 2013-03-05 00:00:00 | [NAME] | 2013-03-15 00:00:00 |  | 11 |  |  | RI | INS
 | 1 |  | Sean | 28 | M | 2013-03-06 00:00:00 | [NAME] | 2013-03-14 00:00:00 | RES | 9 | AMA |  | WA | CASH
 | 1 |  | [NAME] | 35 | M | 2013-03-06 00:00:00 | [NAME] | 2013-04-05 00:00:00 | IOP | 31 | Complete |  | TX | INS
 | 1 |  | Krystina | 19 | F | 2013-03-06 00:00:00 | [NAME] | 2013-04-18 00:00:00 | IOP | 44 | Complete |  | VA | INS
 | 1 |  | Chad | 33 | M | 2013-03-06 00:00:00 | [NAME] | 2013-03-11 00:00:00 | [NAME] | 6 | Complete |  | MD | INS
 | 1 |  | [NAME] | 22 | M | 2013-03-06 00:00:00 | [NAME] | 2013-04-24 00:00:00 | IOP | 50 | Complete |  | NY | INS
 | 1 |  | Justen | 22 | M | 2013-03-06 00:00:00 | [NAME] | 2013-04-06 00:00:00 | RES | 32 | Complete |  | NC | CASH
 | 1 |  | [NAME] | 49 | F | 2013-03-06 00:00:00 | [NAME] | 2013-03-10 00:00:00 | [NAME] | 5 | Complete |  | MO | INS
 | 2 |  | Samantha | 22 | F | 2013-03-07 00:00:00 | [NAME] | 2013-06-10 00:00:00 | IOP | 96 | Complete |  | NY | INS
 | 1 |  | [NAME] | 27 | M | 2013-03-07 00:00:00 | [NAME] | 2013-03-11 00:00:00 | [NAME] | 5 |  |  | TX | INS
 | 1 |  | [NAME] | 22 | M | 2013-03-07 00:00:00 | [NAME] | 2013-04-17 00:00:00 | IOP | 42 | Partial |  | NJ | INS
 | 1 |  | Parker | 19 | M | 2013-03-07 00:00:00 | [NAME] | 2013-03-13 00:00:00 | [NAME] | 7 | Complete |  | FL | INS
 | 1 |  | Macy | 20 | F | 2013-03-08 00:00:00 | [NAME] | 2013-03-18 00:00:00 | PHP | 11 | AMA |  | FL | INS
 | 1 |  | Nylea | 52 | F | 2013-03-08 00:00:00 | [NAME] | 2013-04-08 00:00:00 | IOP | 31 | Complete |  | OH | INS
 | 1 |  | Kimberly | 49 | F | 2013-03-08 00:00:00 | [NAME] | 2013-04-07 00:00:00 | PHP | 31 | Complete |  | WI | INS
 | 4 |  | [NAME] | 26 | F | 2013-03-08 00:00:00 | [NAME] | 2013-03-10 00:00:00 | [NAME] | 3 | AMA |  | FL | INS