Spreadsheet: 289300d1389503401-occurrences-per-week-occurrences-per-week
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
 |  | Employee 1 | 2013-12-17 00:00:00 | Y3 |  |  | FW | 50 | 51 | 52 | 1 | 2 | 3 | 4
 |  | Employee 1 | 2013-12-18 00:00:00 | Y3 |  |  | 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 |  |  | 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
 |  | Employee 3 | 2013-12-02 00:00:00 | [NAME] |  | Time Code
 |  | Employee 3 | 2013-12-03 00:00:00 | [NAME] |  | [NAME] | # | # | # | # | # | # | # | #
 |  | Employee 3 | 2013-12-04 00:00:00 | [NAME] |  | Z5:[NAME] | # | # | # | # | # | # | # | #
 |  | Employee 3 | 2013-12-04 00:00:00 | [NAME] |  | Z6 | # | # | # | # | # | # | # | #
 |  | Employee 3 | 2013-12-05 00:00:00 | [NAME] |  | Y2 | # | # | # | # | # | # | # | #
 |  | Employee 3 | 2013-12-06 00:00:00 | [NAME] |  | Y3 | # | # | # | # | # | # | # | #
 |  | Employee 3 | 2013-12-09 00:00:00 | [NAME]
 |  | Employee 3 | 2013-12-10 00:00:00 | [NAME]
 |  | Employee 3 | 2013-12-11 00:00:00 | [NAME]
 |  | Employee 3 | 2013-12-12 00:00:00 | [NAME]
 |  | Employee 3 | 2013-12-13 00:00:00 | [NAME]
 |  | Employee 3 | 2013-12-13 00:00:00 | [NAME]
 |  | Employee 3 | 2013-12-16 00:00:00 | [NAME]
 |  | Employee 3 | 2013-12-17 00:00:00 | [NAME]
 |  | Employee 3 | 2013-12-18 00:00:00 | [NAME]
 |  | Employee 3 | 2013-12-19 00:00:00 | [NAME]
 |  | Employee 3 | 2013-12-19 00:00:00 | [NAME]
 |  | Employee 3 | 2013-12-20 00:00:00 | [NAME]
 |  | Employee 3 | 2013-12-21 00:00:00 | [NAME]
 |  | Employee 3 | 2013-12-23 00:00:00 | [NAME]
 |  | Employee 3 | 2013-12-24 00:00:00 | [NAME]
 |  | Employee 3 | 2013-12-26 00:00:00 | [NAME]
 |  | Employee 3 | 2013-12-27 00:00:00 | [NAME]
 |  | Employee 3 | 2013-12-30 00:00:00 | [NAME]
 |  | Employee 3 | 2013-12-31 00:00:00 | [NAME]
 |  | Employee 3 | 2014-01-02 00:00:00 | [NAME]
 |  | Employee 3 | 2014-01-03 00:00:00 | [NAME]
 |  | Employee 4 | 2013-12-03 00:00:00 | [NAME]
 |  | Employee 4 | 2013-12-04 00:00:00 | [NAME]
 |  | Employee 4 | 2013-12-05 00:00:00 | [NAME]
 |  | Employee 4 | 2013-12-05 00:00:00 | [NAME]
 |  | Employee 4 | 2013-12-06 00:00:00 | [NAME]
 |  | Employee 4 | 2013-12-09 00:00:00 | [NAME]
 |  | Employee 4 | 2013-12-10 00:00:00 | [NAME]
 |  | Employee 4 | 2013-12-11 00:00:00 | [NAME]
 |  | Employee 4 | 2013-12-12 00:00:00 | [NAME]
 |  | Employee 4 | 2013-12-13 00:00:00 | [NAME]
 |  | Employee 4 | 2013-12-16 00:00:00 | [NAME]
 |  | Employee 4 | 2013-12-17 00:00:00 | [NAME]
 |  | Employee 4 | 2013-12-18 00:00:00 | [NAME]
 |  | Employee 4 | 2013-12-19 00:00:00 | [NAME]
 |  | Employee 4 | 2013-12-23 00:00:00 | [NAME]
 |  | Employee 4 | 2013-12-24 00:00:00 | [NAME]
 |  | Employee 4 | 2013-12-26 00:00:00 | [NAME]
 |  | Employee 4 | 2013-12-27 00:00:00 | [NAME]
 |  | Employee 5 | 2013-12-02 00:00:00 | Z6
 |  | Employee 5 | 2013-12-03 00:00:00 | Z6
 |  | Employee 5 | 2013-12-04 00:00:00 | Z6
 |  | Employee 5 | 2013-12-05 00:00:00 | Z6
 |  | Employee 5 | 2013-12-06 00:00:00 | Z6
 |  | Employee 5 | 2013-12-09 00:00:00 | [NAME]
 |  | Employee 5 | 2013-12-10 00:00:00 | [NAME]
 |  | Employee 5 | 2013-12-11 00:00:00 | [NAME]
 |  | Employee 5 | 2013-12-12 00:00:00 | [NAME]
 |  | Employee 5 | 2013-12-12 00:00:00 | Z5:[NAME]
 |  | Employee 5 | 2013-12-16 00:00:00 | [NAME]
 |  | Employee 5 | 2013-12-17 00:00:00 | [NAME]
 |  | Employee 5 | 2013-12-18 00:00:00 | [NAME]
 |  | Employee 5 | 2013-12-19 00:00:00 | Z5:[NAME]
 |  | Employee 5 | 2013-12-20 00:00:00 | Z5:[NAME]
 |  | Employee 5 | 2013-12-20 00:00:00 | [NAME]
 |  | Employee 5 | 2013-12-23 00:00:00 | [NAME]
 |  | Employee 5 | 2013-12-24 00:00:00 | [NAME]
 |  | Employee 5 | 2013-12-26 00:00:00 | [NAME]
 |  | Employee 5 | 2013-12-27 00:00:00 | [NAME]
 |  | Employee 5 | 2013-12-30 00:00:00 | [NAME]
 |  | Employee 5 | 2013-12-31 00:00:00 | [NAME]
 |  | Employee 5 | 2014-01-02 00:00:00 | [NAME]
 |  | Employee 5 | 2014-01-03 00:00:00 | [NAME]
 |  | Employee 2 | 2013-12-16 00:00:00 | Y2
 |  | Employee 2 | 2013-12-17 00:00:00 | Y2
 |  | Employee 2 | 2013-12-18 00:00:00 | Y2
 |  | Employee 2 | 2013-12-19 00:00:00 | Y2
 |  | Employee 2 | 2013-12-20 00:00:00 | Y2
 |  | Employee 2 | 2013-12-11 00:00:00 | Y2
 |  | Employee 2 | 2013-12-12 00:00:00 | Y2
 |  | Employee 2 | 2013-12-13 00:00:00 | Y2
 |  | Employee 2 | 2013-12-23 00:00:00 | Y2
 |  | Employee 2 | 2013-12-24 00:00:00 | Y2
 |  | Employee 2 | 2013-12-26 00:00:00 | Y2
 |  | Employee 2 | 2013-12-27 00:00:00 | Y2
 |  | Employee 2 | 2013-12-30 00:00:00 | Y2
 |  | Employee 2 | 2013-12-31 00:00:00 | Y2
 |  | Employee 2 | 2014-01-02 00:00:00 | Y2
 |  | Employee 2 | 2014-01-03 00:00:00 | Y2
 |  | Employee 6 | 2013-12-16 00:00:00 | Y3
 |  | Employee 6 | 2013-12-17 00:00:00 | Y3
 |  | Employee 6 | 2013-12-18 00:00:00 | Y3
 |  | Employee 6 | 2013-12-19 00:00:00 | Y3
 |  | Employee 6 | 2013-12-20 00:00:00 | Y3
 |  | Employee 6 | 2013-12-11 00:00:00 | Y3
 |  | Employee 6 | 2013-12-12 00:00:00 | Y3
 |  | Employee 6 | 2013-12-13 00:00:00 | Y3
 |  | Employee 6 | 2013-12-23 00:00:00 | Y3
 |  | Employee 6 | 2013-12-24 00:00:00 | Y3
 |  | Employee 6 | 2013-12-26 00:00:00 | Y3