Counting of a date from a range of Cells
 

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

Counting of a date from a range of Cells
 

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

Counting of a date from a range of Cells
 

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


.

Counting of a date from a range of Cells
 

ok fine , thanks! then how can i count a specific date from a range of column?

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


.

Counting of a date from a range of Cells
 

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


.