Countif, isdate, weeknumber
Hello, I'm trying to write a formula that will count rows containing a date that is part of the current work week. The date column has non date values in a few cells which seems to be throwing off my formula.
This is what I have so far;
I get the error #Invalid Data Type only when the column contains non-date values but I thought the 'isdate' criterion would take care of that.
Help Article Resources
Check out the Formula Handbook template!