=COUNTIF(A1:A11,DATE(2009,1,3))
--
David Biddulph

Manikandan wrote:
ok...fine.... then how can i count a specific date from a range of
data?

"David Biddulph" wrote:

=COUNTIF(A1:A10,"="&DATE(2009,1,1))-COUNTIF(A1:A10,""&DATE(2009,1,5))
if you want the date limits to be inclusive.
If you want the limits to be exclusive, swap the and = signs.
--
David Biddulph

Manikandan wrote:
I have a coulumn which contains somany dates in DD-MM-YY format. I
want to count the number of cells which contain a range of dates
like from 01.01.09 to 05.01.09 etc..

Please help me..


.