Assistance with COUNTIFS and dates


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
    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)))

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!