Spreadsheet: 289314d1389514334-occurrences-per-week-occur-per-wk
Sheet: Sheet1

 |  | Scenario | Employees use assigned time codes to record their hours.  There may be several employees using the same time codes during the week
 |  |  | I am seeking a function (In yellow area) that will find selected Time Code during designated weeks.  However, I am not seeking the frequency of occurrences.
 |  |  | I am seeking one instance per employee during specified dates or weekly.
 |  |  | What is a good function that would work, beginning in Cell [NAME]
 |  |  | Date | Time Code | Charged
 |  | Employee 1 | 2013-12-17 00:00:00 | Y3 | Yes |  |  | FW | 50 | 51 | 52 | 1 | 2 | 3 | 4
 |  | Employee 1 | 2013-12-18 00:00:00 | Y3 | Yes |  |  | Monday's | 2013-12-09 00:00:00 | 2013-12-16 00:00:00 | 2013-12-23 00:00:00 | 2013-12-30 00:00:00 | 2014-01-06 00:00:00 | 2014-01-13 00:00:00 | 2014-01-20 00:00:00
 |  | Employee 1 | 2013-12-23 00:00:00 | Y3 | Yes |  |  | Friday's | 2013-12-15 00:00:00 | 2013-12-22 00:00:00 | 2013-12-29 00:00:00 | 2014-01-05 00:00:00 | 2014-01-12 00:00:00 | 2014-01-19 00:00:00 | 2014-01-26 00:00:00
 |  | Employee 1 | 2013-12-24 00:00:00 | Y3 | Yes
 |  | Employee 3 | 2013-12-02 00:00:00 | [NAME] | Yes |  | Time Code
 |  | Employee 3 | 2013-12-03 00:00:00 | [NAME] | No |  | [NAME]
 |  | Employee 3 | 2013-12-04 00:00:00 | [NAME] | Yes |  | Z5:[NAME]
 |  | Employee 3 | 2013-12-04 00:00:00 | [NAME] | No |  | Z6
 |  | Employee 3 | 2013-12-05 00:00:00 | [NAME] | No |  | Y2
 |  | Employee 3 | 2013-12-06 00:00:00 | [NAME] | Yes |  | Y3
 |  | Employee 3 | 2013-12-09 00:00:00 | [NAME] | No
 |  | Employee 3 | 2013-12-10 00:00:00 | [NAME] | No
 |  | Employee 3 | 2013-12-11 00:00:00 | [NAME] | No
 |  | Employee 3 | 2013-12-12 00:00:00 | [NAME] | No
 |  | Employee 3 | 2013-12-13 00:00:00 | [NAME] | Yes
 |  | Employee 3 | 2013-12-13 00:00:00 | [NAME] | No
 |  | Employee 3 | 2013-12-16 00:00:00 | [NAME] | No
 |  | Employee 3 | 2013-12-17 00:00:00 | [NAME] | No
 |  | Employee 3 | 2013-12-18 00:00:00 | [NAME] | No
 |  | Employee 3 | 2013-12-19 00:00:00 | [NAME] | Yes
 |  | Employee 3 | 2013-12-19 00:00:00 | [NAME] | No
 |  | Employee 3 | 2013-12-20 00:00:00 | [NAME] | No
 |  | Employee 3 | 2013-12-21 00:00:00 | [NAME] | No
 |  | Employee 3 | 2013-12-23 00:00:00 | [NAME] | Yes
 |  | Employee 3 | 2013-12-24 00:00:00 | [NAME] | Yes
 |  | Employee 3 | 2013-12-26 00:00:00 | [NAME] | Yes
 |  | Employee 3 | 2013-12-27 00:00:00 | [NAME] | Yes
 |  | Employee 3 | 2013-12-30 00:00:00 | [NAME] | No
 |  | Employee 3 | 2013-12-31 00:00:00 | [NAME] | No
 |  | Employee 3 | 2014-01-02 00:00:00 | [NAME] | No
 |  | Employee 3 | 2014-01-03 00:00:00 | [NAME] | Yes
 |  | Employee 4 | 2013-12-03 00:00:00 | [NAME] | Yes
 |  | Employee 4 | 2013-12-04 00:00:00 | [NAME] | No
 |  | Employee 4 | 2013-12-05 00:00:00 | [NAME] | No
 |  | Employee 4 | 2013-12-05 00:00:00 | [NAME] | No
 |  | Employee 4 | 2013-12-06 00:00:00 | [NAME] | No
 |  | Employee 4 | 2013-12-09 00:00:00 | [NAME] | No
 |  | Employee 4 | 2013-12-10 00:00:00 | [NAME] | No
 |  | Employee 4 | 2013-12-11 00:00:00 | [NAME] | Yes
 |  | Employee 4 | 2013-12-12 00:00:00 | [NAME] | No
 |  | Employee 4 | 2013-12-13 00:00:00 | [NAME] | Yes
 |  | Employee 4 | 2013-12-16 00:00:00 | [NAME] | Yes
 |  | Employee 4 | 2013-12-17 00:00:00 | [NAME] | No
 |  | Employee 4 | 2013-12-18 00:00:00 | [NAME] | Yes
 |  | Employee 4 | 2013-12-19 00:00:00 | [NAME] | No
 |  | Employee 4 | 2013-12-23 00:00:00 | [NAME] | No
 |  | Employee 4 | 2013-12-24 00:00:00 | [NAME] | Yes
 |  | Employee 4 | 2013-12-26 00:00:00 | [NAME] | Yes
 |  | Employee 4 | 2013-12-27 00:00:00 | [NAME] | No
 |  | Employee 5 | 2013-12-02 00:00:00 | Z6 | No
 |  | Employee 5 | 2013-12-03 00:00:00 | Z6 | No
 |  | Employee 5 | 2013-12-04 00:00:00 | Z6 | Yes
 |  | Employee 5 | 2013-12-05 00:00:00 | Z6 | No
 |  | Employee 5 | 2013-12-06 00:00:00 | Z6 | No
 |  | Employee 5 | 2013-12-09 00:00:00 | [NAME] | Yes
 |  | Employee 5 | 2013-12-10 00:00:00 | [NAME] | Yes
 |  | Employee 5 | 2013-12-11 00:00:00 | [NAME] | No
 |  | Employee 5 | 2013-12-12 00:00:00 | [NAME] | Yes
 |  | Employee 5 | 2013-12-12 00:00:00 | Z5:[NAME] | No
 |  | Employee 5 | 2013-12-16 00:00:00 | [NAME] | No
 |  | Employee 5 | 2013-12-17 00:00:00 | [NAME] | No
 |  | Employee 5 | 2013-12-18 00:00:00 | [NAME] | No
 |  | Employee 5 | 2013-12-19 00:00:00 | Z5:[NAME] | No
 |  | Employee 5 | 2013-12-20 00:00:00 | Z5:[NAME] | Yes
 |  | Employee 5 | 2013-12-20 00:00:00 | [NAME] | No
 |  | Employee 5 | 2013-12-23 00:00:00 | [NAME] | Yes
 |  | Employee 5 | 2013-12-24 00:00:00 | [NAME] | No
 |  | Employee 5 | 2013-12-26 00:00:00 | [NAME] | No
 |  | Employee 5 | 2013-12-27 00:00:00 | [NAME] | No
 |  | Employee 5 | 2013-12-30 00:00:00 | [NAME] | No
 |  | Employee 5 | 2013-12-31 00:00:00 | [NAME] | No
 |  | Employee 5 | 2014-01-02 00:00:00 | [NAME] | Yes
 |  | Employee 5 | 2014-01-03 00:00:00 | [NAME] | No
 |  | Employee 2 | 2013-12-16 00:00:00 | Y2 | Yes
 |  | Employee 2 | 2013-12-17 00:00:00 | Y2 | Yes
 |  | Employee 2 | 2013-12-18 00:00:00 | Y2 | Yes
 |  | Employee 2 | 2013-12-19 00:00:00 | Y2 | No
 |  | Employee 2 | 2013-12-20 00:00:00 | Y2 | No
 |  | Employee 2 | 2013-12-11 00:00:00 | Y2 | Yes
 |  | Employee 2 | 2013-12-12 00:00:00 | Y2 | Yes
 |  | Employee 2 | 2013-12-13 00:00:00 | Y2 | Yes
 |  | Employee 2 | 2013-12-23 00:00:00 | Y2 | No
 |  | Employee 2 | 2013-12-24 00:00:00 | Y2 | Yes
 |  | Employee 2 | 2013-12-26 00:00:00 | Y2 | Yes
 |  | Employee 2 | 2013-12-27 00:00:00 | Y2 | No
 |  | Employee 2 | 2013-12-30 00:00:00 | Y2 | Yes
 |  | Employee 2 | 2013-12-31 00:00:00 | Y2 | Yes
 |  | Employee 2 | 2014-01-02 00:00:00 | Y2 | Yes
 |  | Employee 2 | 2014-01-03 00:00:00 | Y2 | No
 |  | Employee 6 | 2013-12-16 00:00:00 | Y3 | No
 |  | Employee 6 | 2013-12-17 00:00:00 | Y3 | No
 |  | Employee 6 | 2013-12-18 00:00:00 | Y3 | No
 |  | Employee 6 | 2013-12-19 00:00:00 | Y3 | No
 |  | Employee 6 | 2013-12-20 00:00:00 | Y3 | Yes
 |  | Employee 6 | 2013-12-11 00:00:00 | Y3 | No
 |  | Employee 6 | 2013-12-12 00:00:00 | Y3 | No
 |  | Employee 6 | 2013-12-13 00:00:00 | Y3 | No
 |  | Employee 6 | 2013-12-23 00:00:00 | Y3 | No
 |  | Employee 6 | 2013-12-24 00:00:00 | Y3 | Yes
 |  | Employee 6 | 2013-12-26 00:00:00 | Y3 | Yes