Spreadsheet: 266767d1379721382-nested-formula-function-to-count-unique-entries-excel_forum_query2
Sheet: Daily Business Report

DAILY BUSINESS REPORT |  | 2
TOTALS: |  | 15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4.000125266190654
DATE | DAY OF WEEK | # OF WORKERS | Total Net | Profit Sales | Bonus | Ind Comm | Total Payout | Total Change | Total Cash | Total Debit | Total Credit | # Events
2013-09-30 00:00:00 | 2013-09-30 00:00:00 | 14 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3.999999999999999 | <<<This should read "3" for this sample
2013-10-01 00:00:00 | 2013-10-01 00:00:00 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.0001252661906551422 | <<<This should read "4" for this sample
2013-10-02 00:00:00 | 2013-10-02 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2013-10-03 00:00:00 | 2013-10-03 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2013-10-04 00:00:00 | 2013-10-04 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2013-10-05 00:00:00 | 2013-10-05 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2013-10-06 00:00:00 | 2013-10-06 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2013-10-07 00:00:00 | 2013-10-07 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2013-10-08 00:00:00 | 2013-10-08 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2013-10-09 00:00:00 | 2013-10-09 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2013-10-10 00:00:00 | 2013-10-10 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2013-10-11 00:00:00 | 2013-10-11 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2013-10-12 00:00:00 | 2013-10-12 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2013-10-13 00:00:00 | 2013-10-13 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2013-10-14 00:00:00 | 2013-10-14 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2013-10-15 00:00:00 | 2013-10-15 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2013-10-16 00:00:00 | 2013-10-16 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2013-10-17 00:00:00 | 2013-10-17 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2013-10-18 00:00:00 | 2013-10-18 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2013-10-19 00:00:00 | 2013-10-19 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2013-10-20 00:00:00 | 2013-10-20 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2013-10-21 00:00:00 | 2013-10-21 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2013-10-22 00:00:00 | 2013-10-22 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2013-10-23 00:00:00 | 2013-10-23 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2013-10-24 00:00:00 | 2013-10-24 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2013-10-25 00:00:00 | 2013-10-25 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2013-10-26 00:00:00 | 2013-10-26 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2013-10-27 00:00:00 | 2013-10-27 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2013-10-28 00:00:00 | 2013-10-28 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2013-10-29 00:00:00 | 2013-10-29 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2013-10-30 00:00:00 | 2013-10-30 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2013-10-31 00:00:00 | 2013-10-31 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2013-11-01 00:00:00 | 2013-11-01 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2013-11-02 00:00:00 | 2013-11-02 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2013-11-03 00:00:00 | 2013-11-03 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2013-11-04 00:00:00 | 2013-11-04 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2013-11-05 00:00:00 | 2013-11-05 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2013-11-06 00:00:00 | 2013-11-06 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2013-11-07 00:00:00 | 2013-11-07 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2013-11-08 00:00:00 | 2013-11-08 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2013-11-09 00:00:00 | 2013-11-09 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2013-11-10 00:00:00 | 2013-11-10 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2013-11-11 00:00:00 | 2013-11-11 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2013-11-12 00:00:00 | 2013-11-12 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2013-11-13 00:00:00 | 2013-11-13 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2013-11-14 00:00:00 | 2013-11-14 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2013-11-15 00:00:00 | 2013-11-15 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2013-11-16 00:00:00 | 2013-11-16 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2013-11-17 00:00:00 | 2013-11-17 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2013-11-18 00:00:00 | 2013-11-18 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2013-11-19 00:00:00 | 2013-11-19 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2013-11-20 00:00:00 | 2013-11-20 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2013-11-21 00:00:00 | 2013-11-21 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2013-11-22 00:00:00 | 2013-11-22 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2013-11-23 00:00:00 | 2013-11-23 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2013-11-24 00:00:00 | 2013-11-24 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2013-11-25 00:00:00 | 2013-11-25 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2013-11-26 00:00:00 | 2013-11-26 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2013-11-27 00:00:00 | 2013-11-27 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2013-11-28 00:00:00 | 2013-11-28 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2013-11-29 00:00:00 | 2013-11-29 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2013-11-30 00:00:00 | 2013-11-30 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2013-12-01 00:00:00 | 2013-12-01 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2013-12-02 00:00:00 | 2013-12-02 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2013-12-03 00:00:00 | 2013-12-03 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2013-12-04 00:00:00 | 2013-12-04 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2013-12-05 00:00:00 | 2013-12-05 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2013-12-06 00:00:00 | 2013-12-06 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2013-12-07 00:00:00 | 2013-12-07 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2013-12-08 00:00:00 | 2013-12-08 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2013-12-09 00:00:00 | 2013-12-09 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2013-12-10 00:00:00 | 2013-12-10 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2013-12-11 00:00:00 | 2013-12-11 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2013-12-12 00:00:00 | 2013-12-12 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2013-12-13 00:00:00 | 2013-12-13 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2013-12-14 00:00:00 | 2013-12-14 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2013-12-15 00:00:00 | 2013-12-15 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0