Or even shorter:
=SUM((A:ADATE(2009,11,14))*(A:A<DATE(2009,11,21)) )
Pls note:
This is an Array-Formula - to be entered by pressing: CTRL+SHIFT+ENTER.
Micky


"מיכאל (מיקי) אבידן" wrote:

If U R using "Excel 2007/2010" - this might be the shortest formula:
=SUMPRODUCT((A:ADATE(2009,11,14))*(A:A<DATE(2009, 11,21)))
Micky



"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....