I am working within Excel 2016 and I am currently using the following formula to count the number of dates equal to the week number.
=SUMPRODUCT(--(ISOWEEKNUM(A3)=ISOWEEKNUM('---General Chem---'!$E$2:$E$8000)),--(YEAR(A3)=YEAR('---General Chem---'!$E$2:$E$8000)))
This formula works however, I...