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

[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

 

[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)

 

[Bruno Campanini]

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

=SUMPRODUCT((D1070>=DATEVALUE("01-05-04"))*
(D1070<=DATEVALUE("01-07-05")))

Ciao
Bruno