Countif, isdate, weeknumber

SavB. ✭✭
edited 12/09/19 in Formulas and Functions

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;

=Countif([Due Date]:[Due Date], AND(isdate(@cell), weeknumber(@cell)=weeknumber(today())))

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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!