I have data that shows an item description and the sale date, stored in a table. I want to count the number of sales made in a week using the countif function and store it in another table. I have looked and looked, and can't seem to find a solution. Please see the attached Excel file.
I wish I could use something like the following function, but it is invalid.
=COUNTIF(WEEKNUM(Table1[Date]),[@Week])
Thanks in advance.
Bookmarks