greater or equal to 6/01/09 but less than 9/30/09

I assume you mean you want to count *dates* that fall withn a date range.

One way...

Use cells to hold the boundary dates...

A1 = start date
B1 = end date

=COUNTIF(X1:X100,"="&A1)-COUNTIF(X1:X100,"="&B1)

--
Biff
Microsoft Excel MVP


"eubanj" wrote in message
...
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.