Formula counts only if yesterday was a weekday

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

Find more posts tagged with

Accepted answers

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.

All comments

Paul Newcome

Try this:

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

NCH

Paul Newcome

My apologies. It should be a WORKDAY function.

NCH

Thank you Paul. That worked.

Paul Newcome

Great. Happy to help. 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.