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;

=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.

Find more posts tagged with

Sheets

Formulas

Comments

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!

Sign in to join the conversation!

Quick Links

Trending discussions

Dynamic formula to return date of next Thursday every week.
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Check box for date in previous month
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?
Need Help with If, Index, Collect
Please help, I have a few of these to do. I have a nested IF formula. The first part is an INDEX/MATCH and works as a standalone. The next few are INDEX/COLLECT. These are not working as standalone or in the nested version (Unparsable Error). Any ideas? =IF(CONTAINS(“A/V”, [Vendor Type]@row ), INDEX(COLLECT({Date Secured…