Hello, I currently use a function to tally up how many dates I have that fall into a given month with this function: =SUMPRODUCT((MONTH(owssvr!$J$2:$J$500)=MONTH(AF1))*(YEAR(owssvr!$J$2:$J$500)=YEAR(AF1)))

I am trying to convert this to be weekly but WEEKNUM will give #VALUE! if you try to do WEEKNUM over a range like WEEKNUM(owssvr!$J$2:$J$500)=WEEKNUM(AF1). All I'm trying to do is look through an entire column and tally up how many dates are in the week I enter like: 1/5/2014. I would want to add 1 for every entry in my table that falls in that week of that year. Can I do this with WEEKNUM? If not, how else can I? Thank you.

---

Reply from Alex Hedley:

I'd just use the weeknum function against the date for each row.
Now create a pivot table and have the weeknum count.
Or you could do a helper table that goes a CountIf against the new column.