Formula to find many times an employee failed on a task

Robert Harrison

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)))

Bassam Khalil

Hi @Robert Harrison

Hope you are fine, please try the following formula:

=COUNTIFS([Responsible employee]:[Responsible employee], HAS(@cell, "Bassam Khalil"), [ate of failure]:[ate of failure], AND(@cell <= TODAY(), @cell >= TODAY(-28)))

the following screenshot shows the result:

Bassam Khalil

Hi @Robert Harrison

Hope you are fine, please try the following formula:

=COUNTIFS([Responsible employee]:[Responsible employee], HAS(@cell, "Bassam Khalil"), [ate of failure]:[ate of failure], AND(@cell <= TODAY(), @cell >= TODAY(-28)))

the following screenshot shows the result:

Robert Harrison

That worked perfectly. Thank you so much for your help.

Bassam Khalil

@Robert Harrison

Excellent, please accept my answer on this post.