How do I get a count of dates within a range..?
"cmharri123" wrote
in message ...
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((D10:D70=DATEVALUE("01-05-04"))*
(D10:D70<=DATEVALUE("01-07-05")))
Ciao
Bruno
|