I want to count how many active projects from for ex 01/01/2022 to 07/01/2022 if there's an end date then the projected is ended. If not then its still ongoing so don't count it.

CodePudding user response：

try:

=COUNTA(IFNA(FILTER(A:A; B:B>="01/01/2022"; B:B<="07/01/2022"; C:C="")))