Formula to find many times an employee failed on a task
I am trying to write a formula that will keep track on how many times an employee failed to document properly for the last 28 days. Below is the formula I tried with no success ( I have replaced the employee's last name with asterisk's for privacy). I have also attached a screenshot of the sheet I am tracking on.
Any help would be greatly appreciated.
=COUNTIFS([Responsible employee],<>"Brandon ****", [Date of failure], AND(@cell <= TODAY(), @cell >= TODAY(-28)))
Help Article Resources
Check out the Formula Handbook template!