Spreadsheet: 271327d1381913724-how-to-sum-cells-based-off-of-a-date-range-new-test-file-2
Sheet: January 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] | 23 | M | 2013-01-01 00:00:00 | [NAME] | 2013-01-29 00:00:00 | PHP | 29 | Complete |  |  | INS
 | 6 |  | Erin | 29 | F | 2013-01-01 00:00:00 | [NAME] | 2013-01-08 00:00:00 | [NAME] | 8 | Complete |  |  | INS
 | 1 |  | Timothy | 25 | M | 2013-01-01 00:00:00 | [NAME] | 2013-01-23 00:00:00 | IOP | 23 | [NAME] |  |  | INS
 | 1 |  | [NAME] | 25 | M | 2013-01-01 00:00:00 | [NAME] | 2013-01-07 00:00:00 | [NAME] | 7 | Complete |  |  | INS
 | 1 |  | [NAME] | 22 | M | 2013-01-01 00:00:00 | [NAME] | 2013-02-01 00:00:00 | IOP | 32 | Complete |  |  | INS
 | 1 |  | Christian | 40 | M | 2013-01-02 00:00:00 | [NAME] | 2013-01-30 00:00:00 | RES | 29 | Complete |  |  | INS
 | 2 |  | [NAME] | 54 | F | 2013-01-02 00:00:00 | [NAME] | 2013-02-08 00:00:00 | IOP | 38 | Complete |  |  | INS
 | 1 |  | [NAME] | 29 | M | 2013-01-02 00:00:00 | [NAME] | 2013-01-30 00:00:00 | IOP | 30 | Complete |  |  | INS
 | 1 |  | [NAME] | 44 | M | 2013-01-02 00:00:00 | [NAME] | 2013-01-04 00:00:00 | [NAME] | 3 | Complete |  |  | INS
 | 1 |  | [NAME] | 27 | F | 2013-01-02 00:00:00 | [NAME] | 2013-02-22 00:00:00 | IOP | 52 | Complete |  |  | INS
 | 2 |  | Kelsey | 23 | F | 2013-01-02 00:00:00 | [NAME] | 2013-03-11 00:00:00 | IOP | 69 | Complete |  |  | INS
 | 2 |  | [NAME] | 25 | M | 2013-01-02 00:00:00 | [NAME] | 2013-01-05 00:00:00 | RES | 4 | AMA |  |  | INS
 | 1 |  | [NAME] | 20 | M | 2013-01-02 00:00:00 | [NAME] | 2013-01-07 00:00:00 | [NAME] | 6 | Complete |  |  | INS
 | 1 |  | [NAME] | 22 | M | 2013-01-03 00:00:00 | [NAME] | 2013-02-20 00:00:00 | IOP | 49 | Complete |  |  | INS
 | 1 |  | [NAME] | 32 | M | 2013-01-03 00:00:00 | [NAME] | 2013-01-04 00:00:00 | [NAME] | 2 | Complete |  |  | INS
 | 1 |  | [NAME] | 40 | M | 2013-01-03 00:00:00 | [NAME] | 2013-01-30 00:00:00 | RES | 28 | Partial |  |  | CASH
 | 2 |  | Adem | 19 | M | 2013-01-03 00:00:00 | [NAME] | 2013-02-19 00:00:00 | IOP | 48 | Complete |  |  | INS
 | 1 |  | [NAME] | 18 | M | 2013-01-04 00:00:00 | [NAME] | 2013-01-10 00:00:00 | [NAME] | 7 | Complete |  |  | INS
 | 1 |  | [NAME] | 24 | M | 2013-01-04 00:00:00 | [NAME] | 2013-01-10 00:00:00 | [NAME] | 7 | Complete |  |  | INS
 | 2 |  | Samantha | 25 | F | 2013-01-04 00:00:00 | [NAME] | 2013-02-02 00:00:00 | IOP | 30 | Complete
 | 1 |  | [NAME] | 49 | M | 2013-01-04 00:00:00 | [NAME] | 2013-01-26 00:00:00 | PHP | 23 | Partial
 | 1 |  | Iraj | 57 | M | 2013-01-04 00:00:00 | [NAME] | 2013-02-01 00:00:00 | RES | 29 | Complete |  |  | CASH
 | 1 |  | [NAME] | 25 | M | 2013-01-04 00:00:00 | [NAME] | 2013-02-19 00:00:00 | IOP | 47 | Complete
 | 1 |  | Leonard | 21 | M | 2013-01-04 00:00:00 | [NAME] | 2013-02-11 00:00:00 | IOP | 39 | Complete
 | 1 |  | [NAME] | 62 | M | 2013-01-04 00:00:00 | [NAME] | 2013-01-12 00:00:00 | [NAME] | 9 | Complete |  |  | CASH
 | 1 |  | [NAME] | 25 | M | 2013-01-04 00:00:00 | [NAME] | 2013-01-07 00:00:00 | [NAME] | 4 | Other/ [NAME] |  |  | INS
 | 5 |  | [NAME] | 27 | M | 2013-01-04 00:00:00 | [NAME] | 2013-02-09 00:00:00 | RES | 37 | AMA |  |  | INS
 | 1 |  | [NAME] | 21 | M | 2013-01-04 00:00:00 | [NAME] | 2013-01-05 00:00:00 | [NAME] | 2 | Complete
 | 1 |  | [NAME] | 35 | M | 2013-01-04 00:00:00 | [NAME] | 2013-01-05 00:00:00 | [NAME] | 2 | Complete
 | 1 |  | Justin | 24 | M | 2013-01-04 00:00:00 | [NAME] | 2013-01-09 00:00:00 | [NAME] | 6 | Complete
 | 1 |  | [NAME] | 24 | M | 2013-01-04 00:00:00 | [NAME] | 2013-01-07 00:00:00 | [NAME] | 4 | Complete |  |  | INS
 | 1 |  | [NAME] | 43 | M | 2013-01-05 00:00:00 | [NAME] | 2013-04-13 00:00:00 | IOP | 99 | Complete |  |  | INS
 | 4 |  | [NAME] | 26 | M | 2013-01-05 00:00:00 | [NAME] | 2013-01-14 00:00:00 | [NAME] | 10 | Complete |  |  | INS
 | 2 |  | Angila | 21 | F | 2013-01-05 00:00:00 | [NAME] | 2013-01-26 00:00:00 | RES | 22 | Complete |  |  | CASH
 | 5 |  | Kaitlyn | 22 | F | 2013-01-05 00:00:00 | [NAME] | 2013-01-15 00:00:00 | PHP | 11 | AMA |  |  | INS
 | 1 |  | [NAME] | 42 | M | 2013-01-05 00:00:00 | [NAME] | 2013-02-21 00:00:00 | IOP | 48 | Complete |  |  | INS
 | 5 |  | Ariane | 24 | F | 2013-01-05 00:00:00 | [NAME] | 2013-01-12 00:00:00 | [NAME] | 8 | Complete |  |  | INS
 | 2 |  | [NAME] | 22 | M | 2013-01-05 00:00:00 | [NAME] | 2013-01-14 00:00:00 | [NAME] | 10 | Complete |  |  | INS
 | 1 |  | Bradley | 23 | M | 2013-01-05 00:00:00 | [NAME] | 2013-02-14 00:00:00 | IOP | 41 | Complete |  |  | INS
 | 2 |  | [NAME] | 23 | F | 2013-01-05 00:00:00 | [NAME] | 2013-01-13 00:00:00 | [NAME] | 9 | Complete |  |  | INS
 | 1 |  | [NAME] | 25 | M | 2013-01-06 00:00:00 | [NAME] | 2013-02-06 00:00:00 | IOP | 32 | Complete |  |  | INS
 | 1 |  | [NAME] | 25 | M | 2013-01-06 00:00:00 | [NAME] | 2013-02-16 00:00:00 | IOP | 42 | AMA |  |  | INS
 | 1 |  | Shelly | 23 | F | 2013-01-06 00:00:00 | [NAME] | 2013-02-28 00:00:00 | IOP | 34 | AMA |  |  | CASH
 | 1 |  | Stacy | 28 | F | 2013-01-06 00:00:00 | [NAME] | 2013-01-10 00:00:00 | [NAME] | 5 | Complete |  |  | INS
 | 1 |  | Maria | 46 | F | 2013-01-06 00:00:00 | [NAME] | 2013-01-11 00:00:00 | [NAME] | 6 | Complete |  |  | INS
 | 1 |  | [NAME] | 22 | M | 2013-01-06 00:00:00 | [NAME] | 2013-01-07 00:00:00 | [NAME] | 2 | Complete |  |  | INS
 | 2 |  | Adam | 25 | M | 2013-01-06 00:00:00 | [NAME] | 2013-02-06 00:00:00 | IOP | 32 | Complete |  |  | INS
 | 1 |  | Shaina | 24 | F | 2013-01-06 00:00:00 | [NAME] | 2013-01-12 00:00:00 | [NAME] | 7 | Complete |  |  | INS