Formula counts only if yesterday was a weekday

NCH

Hello. I have a formula that counts how many calls an agent took the day before, but I need it not to count Saturdays or Sundays as the day before. Can someone please help me? Here is the formula I have so far.

=COUNTIFS([Agent (Username)]:[Agent (Username)], "Alexis Braxton (ag05ZjnuQISJOOsB63_XyffA)", Period:Period, TODAY(-1), Media:Media, <>"Chat")

NCH

=COUNTIFS([Agent (Username)]:[Agent (Username)], "Alexis Braxton (ag05ZjnuQISJOOsB63_XyffA)", Period:Period, WEEKDAY(TODAY(), -1), Media:Media, <>"Chat") this gives an error of "#INCORRECT ARGUMENT SET."

Paul Newcome

My apologies. It should be a WORKDAY function.

Paul Newcome

Try this:

=COUNTIFS([Agent (Username)]:[Agent (Username)], "Alexis Braxton (ag05ZjnuQISJOOsB63_XyffA)", Period:Period, WEEKDAY(TODAY(), -1), Media:Media, <>"Chat")

NCH

=COUNTIFS([Agent (Username)]:[Agent (Username)], "Alexis Braxton (ag05ZjnuQISJOOsB63_XyffA)", Period:Period, WEEKDAY(TODAY(), -1), Media:Media, <>"Chat") this gives an error of "#INCORRECT ARGUMENT SET."

Paul Newcome

My apologies. It should be a WORKDAY function.

NCH

Thank you Paul. That worked.

Paul Newcome

Great. Happy to help. 👍️