Spreadsheet: 64467d1265308007-formula-to-search-and-select-data-from-multiple-cells-fmla-calculations
Sheet: Calc Eligibility Template 

Employee Name: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | begin date | end date |  | begin date | end date
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009 |  |  | 2010
From the EAS Eligibility Calculator: |  |  |  |  |  |  |  |  |  |  |  | FDO on FMLA Request: |  |  |  |  | 2008-12-13 00:00:00 | 2008-12-26 00:00:00 |  | 2009-12-26 00:00:00 | 2010-01-08 00:00:00
Actual hours worked towards eligibility |  |  |  |  |  |  |  |  |  |  |  | Last Year: | 2009-01-23 00:00:00 |  | This Year: |  | 2008-12-27 00:00:00 | 2009-01-09 00:00:00 |  | 2010-01-09 00:00:00 | 2010-01-22 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | ffff |  |  | 2009-01-10 00:00:00 | 2009-01-23 00:00:00 |  | 2010-01-23 00:00:00 | 2010-02-05 00:00:00
Subtract paid holiday hours. |  |  |  |  | - | 54.25 |  |  |  |  |  |  |  |  |  |  | 2009-01-24 00:00:00 | 2009-02-06 00:00:00 |  | 2010-02-06 00:00:00 | 2010-02-19 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | (dates) | (hours) |  | (dates) | (hours) | 2009-02-07 00:00:00 | 2009-02-20 00:00:00 |  | 2010-02-20 00:00:00 | 2010-03-05 00:00:00
Subtotal |  |  |  |  |  | #N/A | End date of prior pay period: |  |  |  |  | 2009-01-09 00:00:00 |  |  | #N/A |  | 2009-02-21 00:00:00 | 2009-03-06 00:00:00 |  | 2010-03-06 00:00:00 | 2010-03-19 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | - |  |  | + |  | 2009-03-07 00:00:00 | 2009-03-20 00:00:00 |  | 2010-03-20 00:00:00 | 2010-04-02 00:00:00
Subtract hrs worked last year. |  |  |  |  | - | 0 |  |  |  |  | Sa |  | 2009-01-10 00:00:00 | Sa |  |  | 2009-03-21 00:00:00 | 2009-04-03 00:00:00 |  | 2010-04-03 00:00:00 | 2010-04-16 00:00:00
 |  |  |  |  |  |  |  |  |  |  | Su |  | 2009-01-11 00:00:00 | Su |  |  | 2009-04-04 00:00:00 | 2009-04-17 00:00:00 |  | 2010-04-17 00:00:00 | 2010-04-30 00:00:00
Subtotal |  |  |  |  |  | #N/A |  |  |  |  | M |  | 2009-01-12 00:00:00 | M |  |  | 2009-04-18 00:00:00 | 2009-05-01 00:00:00 |  | 2010-05-01 00:00:00 | 2010-05-14 00:00:00
 |  |  |  |  |  |  |  |  |  |  | T |  | 2009-01-13 00:00:00 | T |  |  | 2009-05-02 00:00:00 | 2009-05-15 00:00:00 |  | 2010-05-15 00:00:00 | 2010-05-28 00:00:00
Add hrs worked this year. |  |  |  |  | + | 0 |  |  |  |  | W |  | 2009-01-14 00:00:00 | W |  |  | 2009-05-16 00:00:00 | 2009-05-29 00:00:00 |  | 2010-05-29 00:00:00 | 2010-06-11 00:00:00
 |  |  |  |  |  |  |  |  |  |  | TH |  | 2009-01-15 00:00:00 | TH |  |  | 2009-05-30 00:00:00 | 2009-06-12 00:00:00 |  | 2010-06-12 00:00:00 | 2010-06-25 00:00:00
Total actual hours worked in previous 12 months: |  |  |  |  |  | #N/A |  |  |  |  | F |  | 2009-01-16 00:00:00 | F |  |  | 2009-06-13 00:00:00 | 2009-06-26 00:00:00 |  | 2010-06-26 00:00:00 | 2010-07-09 00:00:00
 |  |  |  |  |  |  |  |  |  |  | Sa |  | 2009-01-17 00:00:00 | Sa |  |  | 2009-06-27 00:00:00 | 2009-07-10 00:00:00 |  | 2010-07-10 00:00:00 | 2010-07-23 00:00:00
 |  |  |  |  |  |  |  |  |  |  | Su |  | 2009-01-18 00:00:00 | Su |  |  | 2009-07-11 00:00:00 | 2009-07-24 00:00:00 |  | 2010-07-24 00:00:00 | 2010-08-06 00:00:00
 |  |  |  |  |  |  |  |  |  |  | M |  | 2009-01-19 00:00:00 | M |  |  | 2009-07-25 00:00:00 | 2009-08-07 00:00:00 |  | 2010-08-07 00:00:00 | 2010-08-20 00:00:00
 |  |  |  |  |  |  |  |  |  |  | T |  | 2009-01-20 00:00:00 | T |  |  | 2009-08-08 00:00:00 | 2009-08-21 00:00:00 |  | 2010-08-21 00:00:00 | 2010-09-03 00:00:00
 |  |  |  |  |  |  |  |  |  |  | W |  | 2009-01-21 00:00:00 | W |  |  | 2009-08-22 00:00:00 | 2009-09-04 00:00:00 |  | 2010-09-04 00:00:00 | 2010-09-17 00:00:00
Highest # of hours for a NO |  |  | 1381.75 |  |  |  |  |  |  |  | TH |  | 2009-01-22 00:00:00 | TH |  |  | 2009-09-05 00:00:00 | 2009-09-18 00:00:00 |  | 2010-09-18 00:00:00 | 2010-10-01 00:00:00
Lowest # of hours for a YES |  |  | 1172.5 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-09-19 00:00:00 | 2009-10-02 00:00:00 |  | 2010-10-02 00:00:00 | 2010-10-15 00:00:00
 |  |  |  |  |  | Subtract hrs worked last year. |  |  |  |  |  |  |  |  |  |  | 2009-10-03 00:00:00 | 2009-10-16 00:00:00 |  | 2010-10-16 00:00:00 | 2010-10-29 00:00:00
 |  |  |  |  |  | Add hrs worked this year. |  |  |  | Total Hours -/+ |  | 0 |  |  | 0 |  | 2009-10-17 00:00:00 | 2009-10-30 00:00:00 |  | 2010-10-30 00:00:00 | 2010-11-12 00:00:00
Holiday Hours |  | Subtract HO only |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-10-31 00:00:00 | 2009-11-13 00:00:00 |  | 2010-11-13 00:00:00 | 2010-11-26 00:00:00
1/1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-11-14 00:00:00 | 2009-11-27 00:00:00 |  | 2010-11-27 00:00:00 | 2010-12-10 00:00:00
5/30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-11-28 00:00:00 | 2009-12-11 00:00:00 |  | 2010-12-11 00:00:00 | 2010-12-24 00:00:00
7/4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-12-12 00:00:00 | 2009-12-25 00:00:00
9/1
11/25
11/26
12/25
Total | 0
2008 U.S. Holiday Schedule |  |  |  |  |  | 2009 Holiday Schedule |  |  |  |  |  | 2010 U.S. Company Holiday Schedule
New Year's Day Tuesday, January 1, 2008 |  |  |  |  |  | New Year’s Day |  | Thursday, January 1, 2009 |  |  |  | New Year's Day |  | Friday, January 1, 2010
Memorial Day Monday, May 26, 2008 |  |  |  |  |  | Memorial Day |  | Monday, May 25, 2009 |  |  |  | Memorial Day |  | Monday, May 31, 2010
Independence Day Friday, July 4, 2008 |  |  |  |  |  | Independence Day |  | Friday, July 3, 2009 |  |  |  | Independence Day |  | Monday July 5, 2010
Labor Day Monday, September 1, 2008 |  |  |  |  |  | Labor Day |  | Monday, September 7, 2009 |  |  |  | Labor Day |  | Monday, September 6, 2010
Thanksgiving Day Thursday, November 27, 2008 |  |  |  |  |  | Thanksgiving Day |  | Thursday, November 26, 2009 |  |  |  | Thanksgiving Day |  | Thursday, November 25, 2010
Day After Thanksgiving Friday, November 28, 2008 |  |  |  |  |  | Day After Thanksgiving** |  | Friday, November 27, 2009 |  |  |  | Day After Thanksgiving |  | Friday, November 26, 2010
Christmas Day Thursday, December 25, 2008 |  |  |  |  |  | Christmas Day |  | Friday, December 25, 2009 |  |  |  | Christmas Day |  | Friday, December 24, 2010