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

Karen Hansard

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.

Paul Newcome

Try this:

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

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. 👍️