Counting of a date from a range of Cells

M

Manikandan

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

David Biddulph

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top