Countif with dates in pivot table..

Hi friends,,,

How to use countif with dates in a pivot table.

I had a worksheet which contains dates as one of the columns in it.

I need the countif of the dates between two dates (Start_date & End_date).My data keeps changing every day.How do i create a template for this kind,so tht it will be helpful to me everyday.I had built a pivot based on the dates column but it show all the dates with count.
Now,i want a formula or structure where in i can choose a start date & end date in the pivot table with count of the dates...

Please help me.....
Thanks in advance...

No ideas still.any help pls...

Can i do this wth sumproduct atleast.