How do I get a count of dates within a range..?

C

cmharri123

I have a column with over a thousand different sale dates within it.
am struggling to get a simple countif formula to give me a total of th
dates within a certain range. I.e. give me the total number of sale
between 01-May-2004 and 01-Jul-2005...

I'm sure this is a simple one... can anyone help..??!

Thanks in advance
 
D

daddylonglegs

If you put your start date in D2, for instance, and end date in D3 this
formula will count dates between and on the two for the given range

=COUNTIF(A1:A1000,">="&D2)-COUNTIF(A1:A1000,">"&D3)
 
B

Bruno Campanini

cmharri123 said:
I have a column with over a thousand different sale dates within it. I
am struggling to get a simple countif formula to give me a total of the
dates within a certain range. I.e. give me the total number of sales
between 01-May-2004 and 01-Jul-2005...
Click to expand...


=SUMPRODUCT((D10:D70>=DATEVALUE("01-05-04"))*
(D10:D70<=DATEVALUE("01-07-05")))

Ciao
Bruno
 

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 multiple occcurrences between date range 3
counting the occurrence of specific text within a date range 4
Count Dates in a range based on Column Header Id without using sum-product 1
Counting number of rows between date range and meeting 2 string criteria 11
Lookup and count all cells that fall between 2 dates 3
Count if data falls within a range AND that has a certain criteria 1
Excel Countif Function - Calculating Between Two Sets of Values 3
Match/Index/Sum function with date range 2

Top