Spreadsheet: 117066d1312416325-sumproduct-match-index-absence-3
Sheet: Sheet3

Absence Data |  |  |  |  |  | Current Employees
Employee Number | Duration | Start date | End Date | Occurence |  | Employee | Monitor Start Date | Monitor End Date | 2 Occurences trigger end date | 4 or more days trigger end date
1 | 2 | 2010-11-04 00:00:00 | 2010-11-05 00:00:00 | 1 |  | 1 | 2011-06-10 00:00:00 | 2011-12-10 00:00:00 | #N/A | #N/A
1 | 1 | 2011-05-31 00:00:00 | 2011-05-31 00:00:00 | 2 |  | 4 | 2011-06-11 00:00:00 | 2011-12-11 00:00:00 | #N/A | #N/A
1 | 1 | 2011-06-09 00:00:00 | 2011-06-09 00:00:00 | 3 |  | 5 | 2011-04-05 00:00:00 | 2011-10-05 00:00:00 | 2011-04-11 00:00:00 | #N/A
1 | 3 | 2011-06-13 00:00:00 | 2011-06-15 00:00:00 | 4 |  | 6 | 2010-11-17 00:00:00 | 2011-05-17 00:00:00 | #N/A | #N/A
2 | 4 | 2011-06-20 00:00:00 | 2011-06-23 00:00:00 | 1 |  | 7 | 2010-10-23 00:00:00 | 2011-04-23 00:00:00 | #N/A | 2010-11-16 00:00:00
3 | 1 | 2010-10-12 00:00:00 | 2010-10-12 00:00:00 | 1 |  | 8 | 2010-12-21 00:00:00 | 2011-06-21 00:00:00 | #N/A | #N/A
4 | 1 | 2010-11-24 00:00:00 | 2010-11-24 00:00:00 | 1 |  | 10 | 2010-10-23 00:00:00 | 2011-04-23 00:00:00 | #N/A | #N/A
4 | 2 | 2011-03-16 00:00:00 | 2011-03-17 00:00:00 | 2 |  | 13 | 2010-10-30 00:00:00 | 2011-04-30 00:00:00 | #N/A | #N/A | <expect D41 to come back
4 | 1 | 2011-06-10 00:00:00 | 2011-06-10 00:00:00 | 3 |  | 14 | 2011-01-21 00:00:00 | 2011-07-21 00:00:00 | #N/A | #N/A
4 | 1 | 2011-07-08 00:00:00 | 2011-07-08 00:00:00 | 4 |  | 15 | 2011-05-18 00:00:00 | 2011-11-18 00:00:00 | #N/A | #N/A
5 | 1 | 2010-10-20 00:00:00 | 2010-10-20 00:00:00 | 1
5 | 2 | 2010-11-25 00:00:00 | 2010-11-26 00:00:00 | 2
5 | 1 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 3
5 | 0 | 2011-04-10 00:00:00 | 2011-04-10 00:00:00 | 4
5 | 1 | 2011-04-11 00:00:00 | 2011-04-11 00:00:00 | 5
6 | 2 | 2010-09-22 00:00:00 | 2010-09-23 00:00:00 | 1
6 | 1 | 2010-11-15 00:00:00 | 2010-11-15 00:00:00 | 2
6 | 1 | 2010-11-16 00:00:00 | 2010-11-16 00:00:00 | 3
7 | 10 | 2010-08-31 00:00:00 | 2010-09-13 00:00:00 | 1
7 | 1 | 2010-10-22 00:00:00 | 2010-10-22 00:00:00 | 2
7 | 15 | 2010-10-27 00:00:00 | 2010-11-16 00:00:00 | 3
7 | 2 | 2010-12-21 00:00:00 | 2010-12-22 00:00:00 | 4
7 | 3 | 2011-02-14 00:00:00 | 2011-02-16 00:00:00 | 5
7 | 4 | 2011-06-14 00:00:00 | 2011-06-17 00:00:00 | 6
8 | 31 | 2010-11-08 00:00:00 | 2010-12-20 00:00:00 | 1
8 | 1 | 2011-07-01 00:00:00 | 2011-07-01 00:00:00 | 2
9 | 2 | 2011-03-24 00:00:00 | 2011-03-25 00:00:00 | 1
9 | 2 | 2011-07-14 00:00:00 | 2011-07-17 00:00:00 | 2
10 | 24 | 2010-09-21 00:00:00 | 2010-10-22 00:00:00 | 1
11 | 2 | 2011-01-10 00:00:00 | 2011-01-11 00:00:00 | 1
11 | 1 | 2011-04-19 00:00:00 | 2011-04-19 00:00:00 | 2
12 | 3 | 2011-01-19 00:00:00 | 2011-01-21 00:00:00 | 1
12 | 2 | 2011-04-04 00:00:00 | 2011-04-05 00:00:00 | 2
13 | 3 | 2010-08-25 00:00:00 | 2010-08-27 00:00:00 | 1
13 | 1 | 2010-10-05 00:00:00 | 2010-10-05 00:00:00 | 2
13 | 1 | 2010-10-29 00:00:00 | 2010-10-29 00:00:00 | 3
13 | 2 | 2011-01-26 00:00:00 | 2011-01-27 00:00:00 | 4
13 | 1 | 2011-03-09 00:00:00 | 2011-03-09 00:00:00 | 5
13 | 3 | 2011-04-19 00:00:00 | 2011-04-21 00:00:00 | 6
13 | 2 | 2011-07-07 00:00:00 | 2011-07-09 00:00:00 | 7
14 | 1 | 2010-11-03 00:00:00 | 2010-11-03 00:00:00 | 1
14 | 2 | 2010-12-02 00:00:00 | 2010-12-03 00:00:00 | 2
14 | 2 | 2011-01-19 00:00:00 | 2011-01-20 00:00:00 | 3
14 | 2 | 2011-05-19 00:00:00 | 2011-05-20 00:00:00 | 4
15 | 1 | 2010-10-05 00:00:00 | 2010-10-05 00:00:00 | 1
15 | 1 | 2011-01-06 00:00:00 | 2011-01-06 00:00:00 | 2
15 | 1 | 2011-05-17 00:00:00 | 2011-05-17 00:00:00 | 3
15 | 1 | 2011-05-20 00:00:00 | 2011-05-20 00:00:00 | 4