With data arranged in this format; use the below formula in D1

Col A Col B Col C Col D
6/1/2009 6/1/2009 9/30/2009 =formula
7/30/2009
8/1/2009
--
--
--

=COUNTIF(A:A,"=" & B1)-COUNTIF(A:A,"=" & C1)


If this post helps click Yes
---------------
Jacob Skaria


"eubanj" wrote:

I need to add all the months that are greater or equal to 6/01/09 but less
than 9/30/09. All the dates are in one column.
Example: 6/01/09 = 1
7/30/09 = 1
8/01/09 = 1
total = 3
Thanks for your help with this.