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

  • Thread starter Thread starter cmharri123
  • Start date Start date
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
 
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)
 
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
 
Back
Top