Counting the number cells between two dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi guys,

Hope someone can help with this, I'm pretty sure it'll be quite a simple one.

Column A:A contains a list dates, I want to use a formula to count the
number of cells which contain a date between 01/01/05 - 31/01/05.

Any ideas,

Many thanks,
Dave
 
Try:

=SUMPRODUCT((A1:A1000>=--"1/1/05")*(A1:A1000<=--
"1/31/05"))

BTW - I'm using American date formats in mine.

HTH
Jason
Atlanta, GA
 
One way:

=COUNTIF(A:A,">="&DATE(2005,1,1))-COUNTIF(A:A,">"&DATE(2005,1,31))
or if you can use less than the whole column:

=SUMPRODUCT(--(TEXT(A1:A999,"yyyymm")="200501"))
 
Try...

=COUNTIF(A:A,">=1/1/2005")-COUNTIF(A:A,">1/31/2005")

Hope this helps!
 
You must log in or register to reply here.

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

Counting Cells with Multiple Range Criteria (Excel 2003) 7
Count specific days in between dates 2
Count Dates between Dates exclude Text 3
counting based on two dates 2
Date Difference in Complete Tax Years 1
Counting Entries between two dates 3
COUNTIF between dates and if value = "y" 8
Show if between two dates 4

Back
Top