Count if formula for a duration of time

Hi All
In the attached excel I just wanted to add Date wise calculation.
In the table called “Weekly AVG” I have already set the formula which I want, Now I want to add the Date in the formula.
Whatever the date I will put in the "Start date" and "End date" in the excel and the data should be reflecting for that same period of time only.

I have tried the below formula in “U7”
=SUMPRODUCT((C:C=T7)*(D:D="<>")*(DATE>=$V$2)*(DATE<=$AE$2))

The above formula is not working this is not working.
But in “U8” I have putted
=IFERROR(COUNTIFS(C:C,T8,D:D,"<>"),"") ----- this is working without any date,

If anyone can help me to get the data it will be a great help.

Regards
Arindam

Attached File : - Countif formula.xlsx

Try this in U7 and copied down:

Formula:

Please Login or Register  to view this content.

BSB

Hi
Thanks for your response,
This is working for "U" line formula, but in V I have a different formula with "Average" it is not working over there.
if you can help me with that, it will be grateful.

Regards
Arindam

Hay this is working....cool...Thanks a lot for your support...