Countif, isdate, weeknumber

SavB.

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. 

L_123

=COUNTIFS([Due Date]:[Due Date], ISDATE(@cell), [Due Date]:[Due Date], WEEKNUMBER(@cell) = WEEKNUMBER(TODAY()))

 

Your issue is the and. Use a countifs instead and create a second criteria for the range.

SavB.

Thanks, this worked!