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 able to separate 2017 dates per week and 2018 dates per week.
Colom A contains the year
Colom B contains the week #
Colom C contains the date
Thanks in advance for your help
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 able to separate 2017 dates per week and 2018 dates per week.
Colom A contains the year
Colom B contains the week #
Colom C contains the date
Thanks in advance for your help