Weeknumber

Jared Pietila

I am trying to pull data for a certain weeknumber. I dont want to use today or today-1 because I want this data to be tracked throughout the quarter? Here is what I have currently trying to find the data for Weeknumber 13.

=COUNTIF({PBR_DateOnly}, AND((IFERROR(WEEKNUMBER(@cell), 0) = WEEKNUMBER(13), IFERROR(YEAR(@cell), 0) = YEAR(TODAY())))

Paul Newcome

You don't need that second WEEKNUMBER function. There is also an extra opening parenthesis after the AND function that needs removed.

=COUNTIF({PBR_DateOnly}, AND(IFERROR(WEEKNUMBER(@cell), 0) = 13, IFERROR(YEAR(@cell), 0) = YEAR(TODAY())))