Assume that you are having the Dates in A Column and do you want to get the
number of days between 15.11.2009 to 20.11.2009.

=VALUE(TEXT(DAY(COUNTIF(A:A,""&DATE(2009,11,14))-COUNTIF(A:A,""&DATE(2009,11,20))),"#########"))

In your example the dates are entered with Full stop (.) instead of / or -
so I think it will not treated as dates. So replace the Full Stops to / or -
for converting it into Dates.

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"Manikandan" wrote:

I have a date range from month first to end of month. I want to count no of
entries from that list which range from 10th to 15th. For eg. a list starting
from 01.11.2009 to 30.11.2009. I want to count no of entries of date range
from 15.11.2009 to 20.11.2009.
Please help me....