Spreadsheet: 268423d1380633738-nested-formula-function-to-count-unique-entries-excel_forum_query-copy
Sheet: Daily Business Report

DAILY BUSINESS REPORT |  | 1
TOTALS: |  | 11 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DATE | DAY OF WEEK | # OF WORKERS | Total Net | Profit Sales | Bonus | Ind Comm | Total Payout | Total Change | Total Cash | Total Debit | Total Credit | # Events | Named Ranges
2013-09-30 00:00:00 | 2013-09-30 00:00:00 | 11 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | Dates
2013-10-01 00:00:00 | 2013-10-01 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | EventLocation
2013-10-02 00:00:00 | 2013-10-02 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | FirstRow
2013-10-03 00:00:00 | 2013-10-03 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | [NAME]
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 | 0
2013-10-12 00:00:00 | 2013-10-12 00:00:00 | 0 | 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 | 0
2013-10-14 00:00:00 | 2013-10-14 00:00:00 | 0 | 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 | 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 | 0
2013-10-18 00:00:00 | 2013-10-18 00:00:00 | 0 | 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 | 0
2013-10-20 00:00:00 | 2013-10-20 00:00:00 | 0 | 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 | 0
2013-10-22 00:00:00 | 2013-10-22 00:00:00 | 0 | 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 | 0
2013-10-24 00:00:00 | 2013-10-24 00:00:00 | 0 | 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 | 0
2013-10-26 00:00:00 | 2013-10-26 00:00:00 | 0 | 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 | 0
2013-10-28 00:00:00 | 2013-10-28 00:00:00 | 0 | 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 | 0
2013-10-30 00:00:00 | 2013-10-30 00:00:00 | 0 | 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 | 0
2013-11-01 00:00:00 | 2013-11-01 00:00:00 | 0 | 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 | 0
2013-11-03 00:00:00 | 2013-11-03 00:00:00 | 0 | 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 | 0
2013-11-05 00:00:00 | 2013-11-05 00:00:00 | 0 | 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 | 0
2013-11-07 00:00:00 | 2013-11-07 00:00:00 | 0 | 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 | 0
2013-11-09 00:00:00 | 2013-11-09 00:00:00 | 0 | 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 | 0
2013-11-11 00:00:00 | 2013-11-11 00:00:00 | 0 | 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 | 0
2013-11-13 00:00:00 | 2013-11-13 00:00:00 | 0 | 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 | 0
2013-11-15 00:00:00 | 2013-11-15 00:00:00 | 0 | 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 | 0
2013-11-17 00:00:00 | 2013-11-17 00:00:00 | 0 | 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 | 0
2013-11-19 00:00:00 | 2013-11-19 00:00:00 | 0 | 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 | 0
2013-11-21 00:00:00 | 2013-11-21 00:00:00 | 0 | 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 | 0
2013-11-23 00:00:00 | 2013-11-23 00:00:00 | 0 | 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 | 0
2013-11-25 00:00:00 | 2013-11-25 00:00:00 | 0 | 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 | 0
2013-11-27 00:00:00 | 2013-11-27 00:00:00 | 0 | 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 | 0
2013-11-29 00:00:00 | 2013-11-29 00:00:00 | 0 | 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 | 0
2013-12-01 00:00:00 | 2013-12-01 00:00:00 | 0 | 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 | 0
2013-12-03 00:00:00 | 2013-12-03 00:00:00 | 0 | 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 | 0
2013-12-05 00:00:00 | 2013-12-05 00:00:00 | 0 | 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 | 0
2013-12-07 00:00:00 | 2013-12-07 00:00:00 | 0 | 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 | 0
2013-12-09 00:00:00 | 2013-12-09 00:00:00 | 0 | 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 | 0
2013-12-11 00:00:00 | 2013-12-11 00:00:00 | 0 | 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 | 0
2013-12-13 00:00:00 | 2013-12-13 00:00:00 | 0 | 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 | 0
2013-12-15 00:00:00 | 2013-12-15 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0