Need to return a count of dates from last week in the current year

Anna Estenzo

Hello,

I'm trying to return a count of how many dates in a column were from last week in the current year. I was using this formula =COUNTIF([Date Step 3 Completed]:[Date Step 3 Completed], IFERROR(WEEKNUMBER(@cell), 0) = WEEKNUMBER(TODAY()) - 1), but I noticed that it started pulling last week's count from 2021 and 2022. I just want it to pull last week's count from 2022.

I'm trying this formula:

=COUNTIFS([Date Step 3 Completed]:[Date Step 3 Completed], IFERROR(YEAR(@cell), 0) = YEAR(TODAY())), IFERROR(WEEKNUMBER(@cell), 0) = WEEKNUMBER(TODAY()) - 1)

But it is flagging as #UNPARSABLE.

Any help would be greatly appreciated.

Thank you!

Kelly Moore

Hey @Anna Estenzo

Try this

=COUNTIFS([Date Step 3 Completed]:[Date Step 3 Completed], IFERROR(YEAR(@cell), 0) = YEAR(TODAY()), [[Date Step 3 Completed]:[Date Step 3 Completed], IFERROR(WEEKNUMBER(@cell), 0) = WEEKNUMBER(TODAY()) - 1)

Does this work for you?

Kelly

Kelly Moore

Hey @Anna Estenzo

Try this

=COUNTIFS([Date Step 3 Completed]:[Date Step 3 Completed], IFERROR(YEAR(@cell), 0) = YEAR(TODAY()), [[Date Step 3 Completed]:[Date Step 3 Completed], IFERROR(WEEKNUMBER(@cell), 0) = WEEKNUMBER(TODAY()) - 1)

Does this work for you?

Kelly

Anna Estenzo

Yes! Thank you so much!! There was an extra bracket in front of the second range, but once I removed that it worked!

=COUNTIFS([Date Step 3 Completed]:[Date Step 3 Completed], IFERROR(YEAR(@cell), 0) = YEAR(TODAY()), [Date Step 3 Completed]:[Date Step 3 Completed], IFERROR(WEEKNUMBER(@cell), 0) = WEEKNUMBER(TODAY()) - 1)

Thanks, Annie