Forum Discussion
Count Dates in Range Based on Criteria
I have the below column of dates in a named range. 9/1/2020 9/8/2020 9/9/2020 9/10/2020 9/15/2020 9/20/2020 9/22/2020 9/28/2020 9/29/2020 10/1/2020 10/2/2020 1...
As an example for month
{=SUM(IF((A1:A15<>"")*(MONTH(A1:A15)=C1), 1/COUNTIF(A1:A15,A1:A15)))}
Array formula: complete the formula with CTRL + SHIFT + RETURN!
The example file is attached.
Hope I could help you in your project.
Nikolino
I know I don't know anything (Socrates)