Hi Excel Wizards;
Last year I was provided the following formula to count the number of dates entered per week in a data set.
=SUM(IF(FREQUENCY(IF($B$2:$B$999997=WEEKNUM($C1017),$C$2:$C$999997),$C$2:$C$999997),1))
Now I have 2 year worth of data in the spread sheet I need the formula to be...