Assistance with COUNTIFS and dates

AERAL

Hi,

I am trying to count the status of a tasks that have range of Start Dates for that week and keep receiving "Unparse" error message.

Paul Newcome

Can you provide the formula you are currently trying?

It should look something like this:

=COUNTIFS({Date Range}, AND(IFERROR(WEEKNUMBER(@cell), 0) = WEEKNUMBER([Target Start Date]@row), IFERROR(YEAR(@cell), 0) = YEAR([Target Start Date]@row)))