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

Similar Threads

Range headings 0
Count Dates & Return as % 2
VBA - exporting serial letters to single documents 0
Creating a Search using a combo box and then creating a report. 4
Date Formats 4
Check dates against a date range. 0
is it possible to sort by approximate date? 2
change DD/MM/YY to MM/DD/YY 6

Top