Spreadsheet: 112450d1308583108-help-with-attendance-tracking-document-formulas-sample-attendance-tracking1
Sheet: Point-leave tracking

Employee Name | First date of absence | Point amount | Reason | Number of days missed. | Comments | FMLA days used in previous 12 months (12 months back from the first date of absence column for each employee) | Point total in previous 3 months (3 months back from the first date of absence column for each employee) Would it be hard to turn this cell red if the total is over 3 points?
[NAME] doe | 2011-06-06 00:00:00 | 0.5 | LE-2 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] doe
The Incredible hulk | 2011-06-10 00:00:00 | 0 | MP1 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Wolverine | 2011-05-24 00:00:00 | 0 | MP1 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Super man | 2011-05-31 00:00:00 | 0 | FL | 3 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Captain America | 2011-05-18 00:00:00 | 0.5 | IL1 | 2 |  |  |  |  |  |  |  |  |  |  |  |  | Captain America
[NAME] | 2011-03-28 00:00:00 | 0.5 | il1 | 3 |  |  |  |  |  |  |  |  |  |  |  |  | The Incredible hulk
Batman | 2011-02-28 00:00:00 | 1.5 | AB2 = Absent without call in | 3 |  |  |  |  |  |  |  |  |  |  |  |  | Iron Man
[NAME] | 2011-02-28 00:00:00 | 0 | FMLA | 28 |  |  |  |  |  |  |  |  |  |  |  |  | Super man
[NAME] doe | 2011-05-23 00:00:00 | 0 | [NAME] | 1 |  |  |  |  |  |  |  |  |  |  |  |  | Batman
Iron Man | 2011-06-01 00:00:00 | 1.5 | AB | 1 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
[NAME] | 2010-07-02 00:00:00 | 0 | FMLA | 28 |  |  |  |  |  |  |  |  |  |  |  |  | Green Gobblin
[NAME] | 2011-03-01 00:00:00 | 0.5 | TL/1 = Tardy/LE 2 + hours | 0.5 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
[NAME] | 2011-04-01 00:00:00 | 0 | FMLA | 0.125 | Took 1 hour for chemo |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Iron Man | 2011-03-28 00:00:00 | 1.5 | AB2 = Absent without call in | 1 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Iron Man | 2011-03-05 00:00:00 | 0.5 | LE= (2 hours remaining) | 0.5 |  |  |  |  |  |  |  |  |  |  |  |  | Wolverine
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Flash
 |  |  |  |  |  |  |  |  |  |  | T1=(Less than 2 hours) |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | LE= (2 hours remaining) |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | IL1= Illness/Injury with doctor's excuse |  |  |  |  |  | Spongebob
 |  |  |  |  |  |  |  |  |  |  | IL2 = (Illness/injury reoccurring within 3 months) |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | MP1 = ([NAME] punch 1st time) |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | MP2 = Miss punch |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | AB = absent call in |  |  |  |  |  | Undertaker
 |  |  |  |  |  |  |  |  |  |  | TL/1 = Tardy/LE 2 + hours |  |  |  |  |  | Troy Aikmen
 |  |  |  |  |  |  |  |  |  |  | AB2 = Absent without call in |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | FMLA |  |  |  |  |  | Mr. Clean
 |  |  |  |  |  |  |  |  |  |  | FMLA vacation |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | WC = Workers comp |  |  |  |  |  | Thor
 |  |  |  |  |  |  |  |  |  |  | FL= funeral leave |  |  |  |  |  | Storm
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  | Optimus Prime
 |  |  |  |  |  |  |  |  |  |  | 0.5 |  |  |  |  |  | Bumblebee
 |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  | Ratchet
 |  |  |  |  |  |  |  |  |  |  | 1.5 |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Iron hide
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Victor
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Papa Smurf
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GI Joe