How to get Workday Function to work with Countifs and Cross-Sheet Reference

I'm attempting to count number of blank values that appear in the sheet 7 reference column, where there is a match on the manager, and the next business day from the Sheet 3 reference column is prior to today.

This is the formula I'm using:

=COUNTIFS({Sheet 7}, "", {Sheet 2}, [Manager]@row, WORKDAY({Sheet 3}, 1) <TODAY())

For instance, if the value in the date column in the Sheet 3 reference is 4/14/23, the Workday +1 value would be 4/17/23 and the WORKDAY({Sheet 3}, 1) <TODAY()) would be true.

The Sheet 3 reference is defined as a Date column.

I get Invalid Data Type as the error. Is what I'm trying to do achievable?

Thanks in advance.

Find more posts tagged with

Accepted answers

Paul Newcome

Try this:

=COUNTIFS({Sheet 7}, "", {Sheet 2}, [Manager]@row, {Sheet 3}, WORKDAY(@cell, 1) <TODAY())

All comments

Paul Newcome

Try this:

=COUNTIFS({Sheet 7}, "", {Sheet 2}, [Manager]@row, {Sheet 3}, WORKDAY(@cell, 1) <TODAY())

Karen Hansard

Hi Paul. That worked! Thank you so much for the quick reply. Have a great day!

Thanks

Paul Newcome

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.