Re: Counting number of dates with specific month
Hi and welcome to the forum.
Another possiblity is to use the AutoFilter with 'Greater than or equal' for 01/06/2012 And 'Less than or equal' for 30/06/2012 and =Subtotal(2,YourRange) for the count of items. You can also then see which items are included.
PS: Nice formula AAE. The -- part, that coerces a boolean to a number right?